| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | PayMethCod | Payment Method Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 2 | Descript | Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | Type | Type | char | 1 | 0 | | | I=Incoming, O=Outgoing | Allow NULL? |
| 4 | BankTransf | Payment Means | char | 1 | 0 | | | B=Bill of Exchange, C=Check, T=Bank Transfer | Allow NULL? |
| 5 | Address | Check Address | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 6 | BankDet | Check Bank Details | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 7 | CllctAutor | Collection Authorization Check | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 8 | FrgnPmntBl | Block Foreign Payment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 9 | FrgnBnkBl | Block Foreign Bank | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 10 | CurrRestr | Currency Restriction | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 11 | PostOffBnk | Post Office Bank | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 12 | MinAmount | Minimum Amount | num | 19 | 6 | | | | Allow NULL? |
| 13 | MaxAmount | Maximum Amount | num | 19 | 6 | | | | Allow NULL? |
| 14 | BnkDflt | Default Bank | nvarchar | 30 | 0 | | | | Allow NULL? |
| 15 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 17 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 18 | BankCountr | Bank Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 19 | DflAccount | Default Account | nvarchar | 50 | 0 | | | | Allow NULL? |
| 20 | GLAccount | G/L Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 21 | Branch | Branch | nvarchar | 50 | 0 | | | | Allow NULL? |
| 22 | KeyCode | Key Code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | TrnsType | Transaction Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | Format | Format | nvarchar | 11 | 0 | | | | Allow NULL? |
| 25 | AgtCollect | Agent Collection | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 26 | SendAccept | Send for Acceptance | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 27 | GrpByDate | Group By Date | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 28 | DepNorm | Deposit Norm | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | DebitMemo | Debit Memo | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 30 | GroupPmRef | Group by Payment Reference No. | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 31 | GroupInv | Group Invoices by Pay | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 32 | ValDateSel | Due Date Selection | char | 1 | 0 | | P | I=Due Date of Invoice, P=Date of Payment Run, T=Payment Terms | Allow NULL? |
| 33 | PaymTerms | Payment Terms Code | int | 6 | 0 | OCTG | | | Allow NULL? |
| 34 | IntrimAcct | Post to G/L Interim Account | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 35 | BnkActKey | Bank Account Internal ID | int | 11 | 0 | DSC1 | | | Allow NULL? |
| 36 | DocType | BoE Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | Accepted | BoE Status - Accepted | char | 1 | 0 | | | | Allow NULL? |
| 38 | PtfID | BoE Internal Portfolio ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | PtfCode | BoE Portfolio Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | PtfNum | BoE Portfolio Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | CurCode | BoE Currency Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | Instruct1 | BoE Instruction 1 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | Instruct2 | BoE Instruction 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | PaymntPlc | BoE Payment Place | nvarchar | 128 | 0 | | | | Allow NULL? |
| 45 | BoeDll | Barcode DLL | nvarchar | 50 | 0 | | | | Allow NULL? |
| 46 | BankCtlKey | Bank Control Number | nvarchar | 2 | 0 | | | | Allow NULL? |
