|
|
API ABOE
ABOE - Bill of Exchange for Payment - History Table
Agent Name OAGP SQL Table
G/L Accounts OACT SQL Table
Countries OCRY SQL Table
Business Partner OCRD SQL Table
Currency Codes OCRN SQL Table
House Bank Accounts DSC1 SQL Table
Payment Methods for Payment Wizard OPYM SQL Table
Portfolio Definitions OPFT SQL Table
Tax Definition OVTG SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BoeKey KEY UNIQUE | Bill of Exchange Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BoeNum KEY UNIQUE | Bill of Exchange No. | Int | 11 | BOE_NUM | Yes | |||
| BoeStatus | Bill of Exchange Status | VarChar | G) Generated S) Sent D) Deposited P) Paid C) Canceled L) Closed F) Failed V) BoE to Vendor | 1 | ||||
| BoeType | Bill of Exchange Type | VarChar | I) Incoming O) Outgoing | 1 | I | |||
| DpsBankCod | Deposit Bank Code | nVarChar | 30 | |||||
| DpsCntrCod | Deposit Country Code | nVarChar | 3 | OCRY Countries | ||||
| DueDate | Bill of Exchange Due Date | Date | 8 | |||||
| DpstAcct | Bank Account No. | nVarChar | 50 | |||||
| DpstBranch | Branch for Payments | nVarChar | 50 | |||||
| Details | Details | nVarChar | 50 | |||||
| TransRef | Journal Entry Reference | nVarChar | 8 | |||||
| PmntDate | Payment Date | Date | 8 | |||||
| PmntNum KEY | Payment No. | Int | 11 | VPM_NUM | No | |||
| BoeSum | Bill of Exchange Amount | Num | 20 | |||||
| BoeSumSC | Bill of Exchange Amount (SC) | Num | 20 | |||||
| BoeSumFC | Bill of Exchange Amount (FC) | Num | 20 | |||||
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| CardName | BP Name | nVarChar | 100 | |||||
| BoeAcct | BP Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| Currency | Bill of Exchange Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| Printed | Printed | VarChar | N) No Y) Yes | 1 | N | |||
| TotalWords | Total in Words | nVarChar | 100 | |||||
| Signature | Signature | nVarChar | 127 | |||||
| TransNum KEY | Transaction No. | Int | 11 | 0 | TRANS_NUM | No | ||
| LinesSum | Row Totals | Num | 20 | |||||
| DdctPrcnt | % Withholding Tax Ded. | Num | 20 | |||||
| Address | Address | nVarChar | 127 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| VatTotal | Total Tax | Num | 20 | |||||
| VatTotalSC | Total Tax (SC) | Num | 20 | |||||
| VatTotalFC | Total Tax (FC) | Num | 20 | |||||
| VatCalcult | Calculate Tax | VarChar | Y) Yes N) No | 1 | N | |||
| TaxDate | Document Date | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Upgrade M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| SumRfndCln | Deduction Refund Amount | Num | 20 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| PrintedBy | Printed By | Int | 6 | |||||
| Transfered | Transferred to next year | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| BPBankCod | BP Bank Code | nVarChar | 30 | |||||
| BPBankNam | BP Bank Name | nVarChar | 127 | |||||
| BPBankAct | BP Bank Account | nVarChar | 50 | |||||
| BPBankBrnc | BP Bank Branch | nVarChar | 50 | |||||
| BPBankCtr | BP Bank Country | nVarChar | 3 | OCRY Countries | ||||
| RefNum | Reference No. | nVarChar | 127 | |||||
| IsReconcld | Reconciled | VarChar | N) No Y) Yes | 1 | N | |||
| Comments | Remarks | nVarChar | 127 | |||||
| PayMethCod | Payment Method Code | nVarChar | 15 | OPYM Payment Methods for Payment Wizard | ||||
| DepositNum KEY | Deposit Number | Int | 11 | DPS_NUM | No | |||
| PymMethNam | Payment Method Name | nVarChar | 100 | |||||
| DeductSum | Deduction Amount | Num | 20 | |||||
| ControlKey | Control Key | nVarChar | 2 | |||||
| AgentCode | Agent Code | nVarChar | 32 | OAGP Agent Name | ||||
| ReconcilNu | External Reconciliation No. | Int | 11 | |||||
| DepositTyp | Deposit Type | VarChar | C) Collection D) Discounted | 1 | ||||
| CreatStatu | Creation Status | VarChar | G) Generated S) Sent | 1 | ||||
| Ref2 | Reference 2 | nVarChar | 127 | |||||
| PayEngSt1 | Payment Engine Status 1 | VarChar | 1 | |||||
| PayEngSt2 | Payment Engine Status 2 | VarChar | 1 | |||||
| PayEngSt3 | Payment Engine Status 3 | nVarChar | 3 | |||||
| StampTax | Stamp Tax Code | nVarChar | 8 | OVTG Tax Definition | ||||
| StmpTxAmnt | Stamp Tax Amount | Num | 20 | |||||
| DpsActKey | Bank Account Internal ID | Int | 11 | DSC1 House Bank Accounts | ||||
| OutBnkKey | Outgoing Bank Account Key | Int | 11 | DSC1 House Bank Accounts | ||||
| Portfolio | Portfolio | nVarChar | 8 | OPFT Portfolio Definitions | ||||
| VndCodeCEE | Vendor Code | nVarChar | 15 | OCRD Business Partner | ||||
| VndNameCEE | Vendor Name | nVarChar | 100 | |||||
| OurNum | Our Number | Int | 11 | |||||
| BarcodeNum | Bar Code Number | nVarChar | 120 | |||||
| BarcodeRep | Bar Code Representation | nVarChar | 100 | |||||
| OurNumChk | Our Number Check Digit | VarChar | 1 | |||||
| FolioPref | Folio Prefix String | nVarChar | 4 | |||||
| FolioNum | Folio Number | Int | 11 | |||||
| LPgFolioN | Folio No. for Last Page in Doc. | Int | 11 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| IntrstAmnt | Interest Amount | Num | 20 | |||||
| DiscAmnt | Discount Amount | Num | 20 | |||||
| FineAmnt | Fine Amount | Num | 20 | |||||
| IntrstDate | BoE Interest Date | Date | 8 | |||||
| DiscDate | BoE Discount Date | Date | 8 | |||||
| FineDate | BoE Fine Date | Date | 8 | |||||
| PostType | Posting Type | VarChar | D) Default A) Alternative | 1 | ||||
| IOFAmnt | IOF Amount | Num | 20 | |||||
| ServFeeAm | Service Fee Amount | Num | 20 | |||||
| OtherExAm | Other Expenses Amount | Num | 20 | |||||
| OtherInAm | Other Incomes Amount | Num | 20 |
Table relationship map
SELECT statement
SELECT
ABOE.BoeKey AS 'Bill of Exchange Key',
ABOE.BoeNum AS 'Bill of Exchange No.',
ABOE.BoeStatus AS 'Bill of Exchange Status',
ABOE.BoeType AS 'Bill of Exchange Type',
ABOE.DpsBankCod AS 'Deposit Bank Code',
ABOE.DpsCntrCod AS 'Deposit Country Code',
ABOE.DueDate AS 'Bill of Exchange Due Date',
ABOE.DpstAcct AS 'Bank Account No.',
ABOE.DpstBranch AS 'Branch for Payments',
ABOE.Details AS 'Details',
ABOE.TransRef AS 'Journal Entry Reference',
ABOE.PmntDate AS 'Payment Date',
ABOE.PmntNum AS 'Payment No.',
ABOE.BoeSum AS 'Bill of Exchange Amount',
ABOE.BoeSumSC AS 'Bill of Exchange Amount (SC)',
ABOE.BoeSumFC AS 'Bill of Exchange Amount (FC)',
ABOE.CardCode AS 'BP Code',
ABOE.CardName AS 'BP Name',
ABOE.BoeAcct AS 'BP Account Code',
ABOE.Currency AS 'Bill of Exchange Currency',
ABOE.Printed AS 'Printed',
ABOE.TotalWords AS 'Total in Words',
ABOE.Signature AS 'Signature',
ABOE.TransNum AS 'Transaction No.',
ABOE.LinesSum AS 'Row Totals',
ABOE.DdctPrcnt AS '% Withholding Tax Ded.',
ABOE.Address AS 'Address',
ABOE.UpdateDate AS 'Date of Update',
ABOE.CreateDate AS 'Creation Date',
ABOE.VatTotal AS 'Total Tax',
ABOE.VatTotalSC AS 'Total Tax (SC)',
ABOE.VatTotalFC AS 'Total Tax (FC)',
ABOE.VatCalcult AS 'Calculate Tax',
ABOE.TaxDate AS 'Document Date',
ABOE.DataSource AS 'Data Source',
ABOE.SumRfndCln AS 'Deduction Refund Amount',
ABOE.UserSign AS 'User Signature',
ABOE.PrintedBy AS 'Printed By',
ABOE.Transfered AS 'Transferred to next year',
ABOE.Instance AS 'Instance',
ABOE.LogInstanc AS 'Log Instance',
ABOE.BPBankCod AS 'BP Bank Code',
ABOE.BPBankNam AS 'BP Bank Name',
ABOE.BPBankAct AS 'BP Bank Account',
ABOE.BPBankBrnc AS 'BP Bank Branch',
ABOE.BPBankCtr AS 'BP Bank Country',
ABOE.RefNum AS 'Reference No.',
ABOE.IsReconcld AS 'Reconciled',
ABOE.Comments AS 'Remarks',
ABOE.PayMethCod AS 'Payment Method Code',
ABOE.DepositNum AS 'Deposit Number',
ABOE.PymMethNam AS 'Payment Method Name',
ABOE.DeductSum AS 'Deduction Amount',
ABOE.ControlKey AS 'Control Key',
ABOE.AgentCode AS 'Agent Code',
ABOE.ReconcilNu AS 'External Reconciliation No.',
ABOE.DepositTyp AS 'Deposit Type',
ABOE.CreatStatu AS 'Creation Status',
ABOE.Ref2 AS 'Reference 2',
ABOE.PayEngSt1 AS 'Payment Engine Status 1',
ABOE.PayEngSt2 AS 'Payment Engine Status 2',
ABOE.PayEngSt3 AS 'Payment Engine Status 3',
ABOE.StampTax AS 'Stamp Tax Code',
ABOE.StmpTxAmnt AS 'Stamp Tax Amount',
ABOE.DpsActKey AS 'Bank Account Internal ID',
ABOE.OutBnkKey AS 'Outgoing Bank Account Key',
ABOE.Portfolio AS 'Portfolio',
ABOE.VndCodeCEE AS 'Vendor Code',
ABOE.VndNameCEE AS 'Vendor Name',
ABOE.OurNum AS 'Our Number',
ABOE.BarcodeNum AS 'Bar Code Number',
ABOE.BarcodeRep AS 'Bar Code Representation',
ABOE.OurNumChk AS 'Our Number Check Digit',
ABOE.FolioPref AS 'Folio Prefix String',
ABOE.FolioNum AS 'Folio Number',
ABOE.LPgFolioN AS 'Folio No. for Last Page in Doc.',
ABOE.UserSign2 AS 'Updating User',
ABOE.IntrstAmnt AS 'Interest Amount',
ABOE.DiscAmnt AS 'Discount Amount',
ABOE.FineAmnt AS 'Fine Amount',
ABOE.IntrstDate AS 'BoE Interest Date',
ABOE.DiscDate AS 'BoE Discount Date',
ABOE.FineDate AS 'BoE Fine Date',
ABOE.PostType AS 'Posting Type',
ABOE.IOFAmnt AS 'IOF Amount',
ABOE.ServFeeAm AS 'Service Fee Amount',
ABOE.OtherExAm AS 'Other Expenses Amount',
ABOE.OtherInAm AS 'Other Incomes Amount'
FROM ABOE AS ABOE
Related information
Agent Name OAGP SQL Table
G/L Accounts OACT SQL Table
Countries OCRY SQL Table
Business Partner OCRD SQL Table
Currency Codes OCRN SQL Table
House Bank Accounts DSC1 SQL Table
Payment Methods for Payment Wizard OPYM SQL Table
Portfolio Definitions OPFT SQL Table
Tax Definition OVTG SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
