| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | WizardId | Wizard ID | int | 11 | 0 | ODWZ | | | Allow NULL? |
| 2 | CardCode | BP Card Code | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 3 | LetterNum | Letter Number | int | 11 | 0 | | | | Allow NULL? |
| 4 | TotalFee | Total Fee | num | 19 | 6 | | | | Allow NULL? |
| 5 | FeeCurr | Total Fee Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 6 | TtlopnIntr | Sum of Open Sum+Interest | num | 19 | 6 | | | | Allow NULL? |
| 7 | EDunLevel | Edited Dunning Level | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | OpnIntrCrr | Total Open + Interest Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | DocAbs | Document Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 10 | DocNum | Doc. No. | int | 11 | 0 | | | | Allow NULL? |
| 11 | InstlmntID | Installment ID | int | 6 | 0 | | | | Allow NULL? |
| 12 | IntrstPC | Interest Percent | num | 19 | 6 | | | | Allow NULL? |
| 13 | IntrstAmnt | Interest Amount | num | 19 | 6 | | | | Allow NULL? |
| 14 | IntrstCurr | Interest Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 15 | ChckLine | Checked Row | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 16 | IntrstDays | Interest Days | int | 11 | 0 | | | | Allow NULL? |
| 17 | DocType | Source Table | int | 11 | 0 | | | -2=Open Balance, -3=Close Balance, 13=A/R Invoice, 14=A/R Credit Memo, 165=Correction A/R Invoice, 203=Down Payment Incoming, 24=Incoming Payment, 30=Journal Transactions, 46=Outgoing Payments | Allow NULL? |
| 18 | DueDate | Due Date | date | 8 | 0 | | | | |
| 19 | LetterLvl | Letter Level | nvarchar | 3 | 0 | | 0 | | Allow NULL? |
| 20 | OpenSum | Open Sum | num | 19 | 6 | | | | Allow NULL? |
| 21 | OpenCurr | Open Sum Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | sumIntrClc | Sum for Interest Calculation | num | 19 | 6 | | | | Allow NULL? |
| 23 | folioNum | Folio Number | nvarchar | 14 | 0 | | | | Allow NULL? |
| 24 | LvlUpdated | Level Updated Flag | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 25 | TotalFeeFC | Total Fee in Document Currency | num | 19 | 6 | | | | Allow NULL? |
| 26 | TotalFeeLC | Total Fee in Local Currency | num | 19 | 6 | | | | Allow NULL? |
| 27 | TotalFeeSC | Total Fee in System Currency | num | 19 | 6 | | | | Allow NULL? |
| 28 | TtlopnInFC | Sum of Open Sum+Interest FC | num | 19 | 6 | | | | Allow NULL? |
| 29 | TtlopnInSC | Sum of Open Sum+Interest SC | num | 19 | 6 | | | | Allow NULL? |
| 30 | IntrAmtFC | Interest Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 31 | IntrAmtSC | Interest Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 32 | OpenSumFC | Open Sum (FC) | num | 19 | 6 | | | | Allow NULL? |
| 33 | OpenSumSC | Open Sum (SC) | num | 19 | 6 | | | | Allow NULL? |
| 34 | ExeChkLine | Executed Checked Row | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 35 | AutoPost | Automatic Posting | char | 1 | 0 | | N | B=Interest and Fee, F=Fee Only, I=Interest Only, N=No | Allow NULL? |
| 36 | DocRate | Document Rate | num | 19 | 6 | | | | Allow NULL? |
| 37 | UnpaidBoEV | Unpaid BoE Value | num | 19 | 6 | | | | Allow NULL? |
| 38 | BoENumber | BoE Number | int | 11 | 0 | | | | Allow NULL? |
| 39 | BoEStatus | BoE Status | char | 1 | 0 | | | | Allow NULL? |
| 40 | BoEDate | BoE Date | date | 8 | 0 | | | | |
| 41 | BoEKey | BoE Key | int | 11 | 0 | | | | Allow NULL? |
| 42 | BPType | Business Partner Type | char | 1 | 0 | | C | C=Customer, S=Vendor | Allow NULL? |
| 43 | BPLId | Assigned Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
