| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocNum | Document Number | int | 11 | 0 | OVPM | | | Allow NULL? |
| 2 | InvoiceId | Sequence No. | int | 11 | 0 | | | | Allow NULL? |
| 3 | DocEntry | Invoice Key | int | 11 | 0 | | | | Allow NULL? |
| 4 | SumApplied | Paid (LC) | num | 19 | 6 | | | | Allow NULL? |
| 5 | AppliedFC | Paid (FC) | num | 19 | 6 | | | | Allow NULL? |
| 6 | AppliedSys | Paid (SC) | num | 19 | 6 | | | | Allow NULL? |
| 7 | InvType | Document Type | nvarchar | 20 | 0 | | 13 | -1=All Transactions, -2=Opening Balance, -3=Closing Balance, 0, 13=A/R Invoice, 14=A/R Credit Memo, 163=A/P Correction Invoice, 165=A/R Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 24=Incoming Payment, 25=Deposit, 30=Journal Entry, 46=Payment Advice, 57=Checks for Payment, 76=Postdated | Allow NULL? |
| 8 | DocRate | Document Rate | num | 19 | 6 | | | | Allow NULL? |
| 9 | Flags | Flags | int | 11 | 0 | | 0 | | Allow NULL? |
| 10 | IntrsStat | Interest Letter Status | char | 1 | 0 | | U | C=Closed, S=Sent, U=Not Sent | Allow NULL? |
| 11 | DocLine | Row Key | int | 11 | 0 | | 0 | | Allow NULL? |
| 12 | vatApplied | Tax Definition | num | 19 | 6 | | | | Allow NULL? |
| 13 | vatAppldFC | Tax Paid (FC) | num | 19 | 6 | | | | Allow NULL? |
| 14 | vatAppldSy | Tax Paid (SC) | num | 19 | 6 | | | | Allow NULL? |
| 15 | selfInv | Auto. Invoice | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 16 | ObjType | Object Type | nvarchar | 20 | 0 | ADP1 | | | Allow NULL? |
| 17 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 18 | Dcount | Discount | num | 19 | 6 | | | | Allow NULL? |
| 19 | DcntSum | Discount Amount | num | 19 | 6 | | | | Allow NULL? |
| 20 | DcntSumFC | Discount Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 21 | DcntSumSy | Discount Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 22 | BfDcntSum | Amount Bef. Discount | num | 19 | 6 | | | | Allow NULL? |
| 23 | BfDcntSumF | Amount Bef. Discount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 24 | BfDcntSumS | Amount Bef. Discount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 25 | BfNetDcnt | Net Amount Bef. Discount | num | 19 | 6 | | | | Allow NULL? |
| 26 | BfNetDcntF | Net Amount Bef. Discount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 27 | BfNetDcntS | Net Amount Bef. Discount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 28 | PaidSum | Amount Paid (LC) | num | 19 | 6 | | | | Allow NULL? |
| 29 | ExpAppld | Freight applied | num | 19 | 6 | | | | Allow NULL? |
| 30 | ExpAppldFC | Freight applied FC | num | 19 | 6 | | | | Allow NULL? |
| 31 | ExpAppldSC | Freight applied SC | num | 19 | 6 | | | | Allow NULL? |
| 32 | Rounddiff | Rounding Diff. | num | 19 | 6 | | | | Allow NULL? |
| 33 | RounddifFc | Rounding Diff. (FC) | num | 19 | 6 | | | | Allow NULL? |
| 34 | RounddifSc | Rounding Diff. (SC) | num | 19 | 6 | | | | Allow NULL? |
| 35 | InstId | Installment ID | int | 6 | 0 | | 1 | | Allow NULL? |
| 36 | WtAppld | Applied WTax | num | 19 | 6 | | | | Allow NULL? |
| 37 | WtAppldFC | Applied WT (FC) | num | 19 | 6 | | | | Allow NULL? |
| 38 | WtAppldSC | Applied WTax (SC) | num | 19 | 6 | | | | Allow NULL? |
| 39 | LinkDate | Link Date | date | 8 | 0 | | | | |
| 40 | AmtDifPst | Amount Diffs. Posting Date | date | 8 | 0 | | | | |
| 41 | PaidDpm | Paid Down Payment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 42 | DpmPosted | Link Date | char | 1 | 0 | | | | Allow NULL? |
| 43 | ExpVatSum | VAT on Expenses Sum | num | 19 | 6 | | | | Allow NULL? |
| 44 | ExpVatSumF | VAT on Expenses Sum (FC) | num | 19 | 6 | | | | Allow NULL? |
| 45 | ExpVatSumS | VAT on Expenses Sum (SC) | num | 19 | 6 | | | | Allow NULL? |
| 46 | IsRateDiff | Is Exchange Rate | char | 1 | 0 | | N | | Allow NULL? |
| 47 | WtInvCatS | Withholding Tax Invoice Categ. | num | 19 | 6 | | | | Allow NULL? |
| 48 | WtInvCatSF | Withholding Tax Invoice Categ. | num | 19 | 6 | | | | Allow NULL? |
| 49 | WtInvCatSS | Withholding Tax Invoice Categ. | num | 19 | 6 | | | | Allow NULL? |
| 50 | OcrCode | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 51 | DocTransId | Trans. ID of Paid Document | int | 11 | 0 | OJDT | | | Allow NULL? |
| 52 | MIEntry | MI Entry Include this Payment | int | 11 | 0 | | 0 | | Allow NULL? |
| 53 | OcrCode2 | Distribution Rule2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 54 | OcrCode3 | Distribution Rule3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 55 | OcrCode4 | Distribution Rule4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 56 | OcrCode5 | Distribution Rule5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 57 | IsSelected | Is Record Selected | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 58 | WTOnHold | Withholding Tax On Hold | num | 19 | 6 | | | | Allow NULL? |
| 59 | WTOnhldPst | Withholding Tax Posted | num | 19 | 6 | | | | Allow NULL? |
| 60 | baseAbs | Base Document Number | int | 11 | 0 | | | | Allow NULL? |
| 61 | MIType | MI Type Include this Payment | nvarchar | 20 | 0 | | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice | Allow NULL? |
| 62 | DocSubType | Document Subtype | nvarchar | 2 | 0 | | -- | | Allow NULL? |
| 63 | SpltPmtVAT | Split Payment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
