biuan SAP® BUSINESS ONE SDK
API OSAL
OSAL - Outgoing Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEYDocument NumberInt
11
NUMNo
BaseDocNum KEYBase Document NumberInt
11
BASE_DOCNo
PrintedPrintedVarChar
Y) Copy
N) Original
1
N
ObjType KEYObject TypenVarChar
20ADP1
Object Settings - History
OBJECTNo
DocDatePosting DateDate
8
DocDueDateDue DateDate
8
CardCodeBP CodenVarChar
15OCRD
Business Partner
CardNameBP NamenVarChar
100
FreZoneNumID NumbernVarChar
8
ShiperSendernVarChar
100
AddressAddressnVarChar
127
FromCntryCountry - OriginnVarChar
100
ToCntryCountry - DestinationnVarChar
100
FromPortOrigin PortnVarChar
100
ToPortDestination PortnVarChar
100
AirPlaneShip/AircraftnVarChar
50
AirPlanNumNo. of Ships/AircraftnVarChar
40
TotalFobTotalNum
20
TaxesTaxesNum
20
InsuranceInsuranceNum
20
OthersOtherNum
20
TotalCifDocument TotalNum
20
Ref1Reference 1nVarChar
11
Ref2Reference 2nVarChar
11
CommentsRemarksnVarChar
127
GroupNumPayment Terms CodeInt
6OCTG
Payment Terms
DocTimeDocument TimeInt
6
SlpCodeSales EmployeeInt
11OSLP
Sales Employee
-1
TrnspCodeDelivery CodeInt
6OSHP
Delivery Types
-1
PartSupplyDelivery of GoodsVarChar
Y) Yes
N) No
1
Y
ImportEntLanded CostsInt
11OIPF
Landed Costs
CreateDateCreation DateDate
8
UpdateDateDate of UpdateDate
8
NumForPrnBase Doc. No. for PrintingnVarChar
16
PurPackMsrPackaging UoM NamenVarChar
8
Series KEYSeriesInt
6
SERIESNo
BaseDocObjBase Document Object TypeInt
6
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OSAL.DocEntry AS 'Internal Number', OSAL.DocNum AS 'Document Number', OSAL.BaseDocNum AS 'Base Document Number', OSAL.Printed AS 'Printed', OSAL.ObjType AS 'Object Type', OSAL.DocDate AS 'Posting Date', OSAL.DocDueDate AS 'Due Date', OSAL.CardCode AS 'BP Code', OSAL.CardName AS 'BP Name', OSAL.FreZoneNum AS 'ID Number', OSAL.Shiper AS 'Sender', OSAL.Address AS 'Address', OSAL.FromCntry AS 'Country - Origin', OSAL.ToCntry AS 'Country - Destination', OSAL.FromPort AS 'Origin Port', OSAL.ToPort AS 'Destination Port', OSAL.AirPlane AS 'Ship/Aircraft', OSAL.AirPlanNum AS 'No. of Ships/Aircraft', OSAL.TotalFob AS 'Total', OSAL.Taxes AS 'Taxes', OSAL.Insurance AS 'Insurance', OSAL.Others AS 'Other', OSAL.TotalCif AS 'Document Total', OSAL.Ref1 AS 'Reference 1', OSAL.Ref2 AS 'Reference 2', OSAL.Comments AS 'Remarks', OSAL.GroupNum AS 'Payment Terms Code', OSAL.DocTime AS 'Document Time', OSAL.SlpCode AS 'Sales Employee', OSAL.TrnspCode AS 'Delivery Code', OSAL.PartSupply AS 'Delivery of Goods', OSAL.ImportEnt AS 'Landed Costs', OSAL.CreateDate AS 'Creation Date', OSAL.UpdateDate AS 'Date of Update', OSAL.NumForPrn AS 'Base Doc. No. for Printing', OSAL.PurPackMsr AS 'Packaging UoM Name', OSAL.Series AS 'Series', OSAL.BaseDocObj AS 'Base Document Object Type', OSAL.DataSource AS 'Data Source', OSAL.UserSign AS 'User Signature' FROM OSAL AS OSAL

Related information


Business Partner OCRD SQL Table

Payment Terms OCTG SQL Table

Landed Costs OIPF SQL Table

Object Settings - History ADP1 SQL Table

Sales Employee OSLP SQL Table

Delivery Types OSHP SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates