| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | ReconNum | Reconciliation Number | int | 11 | 0 | OITR | | | Allow NULL? |
| 2 | LineSeq | Row Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | ShortName | BP/Account Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 4 | TransId | Transaction Internal ID | int | 11 | 0 | OJDT | | | Allow NULL? |
| 5 | TransRowId | Transaction Row Number | int | 11 | 0 | | | | Allow NULL? |
| 6 | SrcObjTyp | Source Object Type | nvarchar | 20 | 0 | | | 13, 14, 163, 164, 165, 166, 18, 19, 203, 204, 24, 30, 46 | Allow NULL? |
| 7 | SrcObjAbs | Source Object Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 8 | ReconSum | Reconciliation Amount | num | 19 | 6 | | | | Allow NULL? |
| 9 | ReconSumFC | Reconciliation Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 10 | ReconSumSC | Reconciliation Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 11 | FrgnCurr | Foreign Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 12 | SumMthCurr | Amt in Reconciliation Currency | num | 19 | 6 | | | | Allow NULL? |
| 13 | IsCredit | Credit or Debit | char | 1 | 0 | | | C, D | Allow NULL? |
| 14 | Account | Account Code | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 15 | CashDisSum | Cash Discount Amount | num | 19 | 6 | | | | Allow NULL? |
| 16 | WTSum | Withholding Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 17 | WTSumFC | Withholding Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 18 | WTSumSC | Withholding Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 19 | ExpSum | Freight Amount | num | 19 | 6 | | | | Allow NULL? |
| 20 | ExpSumFC | Freight Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 21 | ExpSumSC | Freight Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 22 | netBefDisc | Net Before Discount Sum | num | 19 | 6 | | | | Allow NULL? |
| 23 | MIEntry | MI Entry Include this Recon. | int | 11 | 0 | | 0 | | Allow NULL? |
| 24 | MIType | MI Type Include this Recon. | nvarchar | 20 | 0 | | | 140000014, 270 | Allow NULL? |