| 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 | Check Collection Authorization | 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 Bank Account | nvarchar | 50 | 0 | | | | Allow NULL? |
| 20 | GLAccount | G/L Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 21 | Branch | Bank 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 | File Format | nvarchar | 11 | 0 | OFRM | | | 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 Key | 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 | Bar Code DLL | nvarchar | 50 | 0 | | | | Allow NULL? |
| 46 | BankCtlKey | Bank Control No. | nvarchar | 2 | 0 | | | | Allow NULL? |
| 47 | Active | Status of the Payment Method | char | 1 | 0 | | Y | N=Inactive, Y=Active | Allow NULL? |
| 48 | BcgPcnt | Bank Charge Rate (%) | num | 19 | 6 | | | | Allow NULL? |
| 49 | GrpByCur | Group Invoices by Currency | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 50 | GrpByBank | Group Invoices by Pay-To Bank | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 51 | DflIBAN | Bank IBAN | nvarchar | 50 | 0 | | | | Allow NULL? |
| 52 | DflSwift | Bank BIC/SWIFT | nvarchar | 50 | 0 | | | | Allow NULL? |
| 53 | BoeReport | BoE Report Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 54 | CancInstr | Cancellation Instruction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 55 | OccurCode | Occurrence Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 56 | MovmntCode | Movement Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | NegPymCode | Negative Payment Method Code | nvarchar | 15 | 0 | OPYM | | | Allow NULL? |
| 58 | DirectDbt | Direct Debit | nvarchar | 5 | 0 | | | B2B, COR1, CORE | Allow NULL? |
| 59 | IssueIndic | Issue Indicator | char | 1 | 0 | | R | 3, R | Allow NULL? |
| 60 | PrintSEPA | Print SEPA Prenotification | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 61 | PmntType | Payment Type | nvarchar | 50 | 0 | | 01 | 01=Efectivo, 02=Cheque nominativo, 03=Transferencia electrónica de fondos, 04=Tarjeta de crédito, 05=Monedero electrónico, 06=Dinero electrónico, 08=Vales de despensa, 12=Dación en pago, 13=Pago por subrogación, 14=Pago por consignación, 15=Condonación, 17=Compensación, 23=Novación, 24=Confusión, 25=Remisión de deuda, 26=Prescripción o cad | Allow NULL? |
| 62 | GrpByAgrNo | Group Blanket Agreement | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 63 | SpltPmtVAT | Split Payments for VAT | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
