| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | BatchNum | Journal Voucher No. | int | 11 | 0 | OBTD | | | Allow NULL? |
| 2 | TransId | Transaction Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | BtfStatus | Status | char | 1 | 0 | | O | C=Closed, O=Open | Allow NULL? |
| 4 | TransType | Original Journal | nvarchar | 20 | 0 | | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, -3=Closing Balance, 10000046=Data Archive, 10000071=Inventory Posting, 10000079=TDS Adjustment, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Valuation, 163=A/P Correction Invoice, 1 | Allow NULL? |
| 5 | BaseRef | Base Reference | nvarchar | 11 | 0 | | | | Allow NULL? |
| 6 | RefDate | Posting Date | date | 8 | 0 | | | | |
| 7 | Memo | Details | nvarchar | 50 | 0 | | | | Allow NULL? |
| 8 | Ref1 | Reference 1 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 9 | Ref2 | Reference 2 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 10 | CreatedBy | Original | int | 11 | 0 | | | | Allow NULL? |
| 11 | LocTotal | Total (LC) | num | 19 | 6 | | | | Allow NULL? |
| 12 | FcTotal | Total (FC) | num | 19 | 6 | | | | Allow NULL? |
| 13 | SysTotal | Total (SC) | num | 19 | 6 | | | | Allow NULL? |
| 14 | TransCode | Transaction Code | nvarchar | 4 | 0 | OTRC | | | Allow NULL? |
| 15 | OrignCurr | Revaluation Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 16 | TransRate | Revaluation Rate | num | 19 | 6 | | | | Allow NULL? |
| 17 | BtfLine | Row in Voucher | int | 11 | 0 | | | | Allow NULL? |
| 18 | TransCurr | Transaction Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | Project | Project Code | nvarchar | 8 | 0 | OPRJ | | | Allow NULL? |
| 20 | DueDate | Due Date | date | 8 | 0 | | | | |
| 21 | TaxDate | Document Date | date | 8 | 0 | | | | |
| 22 | PCAddition | PC Addition | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 23 | FinncPriod | Posting Period | int | 11 | 0 | OFPR | | | Allow NULL? |
| 24 | 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? |
| 25 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 26 | CreateDate | Recording Date | date | 8 | 0 | | | | |
| 27 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 28 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 29 | RefndRprt | Repayment Report | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 30 | LogInstanc | Log Instance | int | 6 | 0 | | 0 | | Allow NULL? |
| 31 | ObjType | Object Type | nvarchar | 20 | 0 | | 30 | | Allow NULL? |
| 32 | Indicator | Indicator Code | nvarchar | 2 | 0 | OIDC | | | Allow NULL? |
| 33 | AdjTran | Adjusting Transaction | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 34 | RevSource | Revaluation Source | char | 1 | 0 | | N | F=FC, N=No, S=System | Allow NULL? |
| 35 | StornoDate | Reversal Date | date | 8 | 0 | | | | |
| 36 | StornoToTr | Reverse Transaction | int | 11 | 0 | | | | Allow NULL? |
| 37 | AutoStorno | Use Auto-Reverse | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 38 | Corisptivi | Transaction Values | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 39 | VatDate | Document Date | date | 8 | 0 | | | | |
| 40 | StampTax | Stamp Tax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 41 | Series | Series | int | 6 | 0 | | 0 | | Allow NULL? |
| 42 | Number | Number | int | 11 | 0 | | | | Allow NULL? |
| 43 | AutoVAT | Automatic VAT | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 44 | DocSeries | Document Series | int | 6 | 0 | | | | Allow NULL? |
| 45 | FolioPref | Folio Prefix String | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | FolioNum | Folio Number | int | 11 | 0 | | | | Allow NULL? |
| 47 | CreateTime | Generation Time | int | 6 | 0 | | | | Allow NULL? |
| 48 | BlockDunn | Block Dunning Letter | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 49 | ReportEU | Include in EU Report | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 50 | Report347 | Include in 347 Report | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 51 | Printed | Printed | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 52 | DocType | Document Type | nvarchar | 12 | 0 | | | | Allow NULL? |
| 53 | AttNum | Number of Attachments | int | 11 | 0 | | 0 | | Allow NULL? |
| 54 | GenRegNo | Generate Reg. No. or Not | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 55 | RG23APart2 | RG23A Part2 No | int | 11 | 0 | | | | Allow NULL? |
| 56 | RG23CPart2 | RG23C Part2 No | int | 11 | 0 | | | | Allow NULL? |
| 57 | MatType | Material Type | int | 11 | 0 | | | | Allow NULL? |
| 58 | Creator | Creator Name | nvarchar | 63 | 0 | | | | Allow NULL? |
| 59 | Approver | Approver Name | nvarchar | 63 | 0 | | | | Allow NULL? |
| 60 | Location | Loc. | int | 11 | 0 | OLCT | | | Allow NULL? |
| 61 | SeqCode | Sequence Code | int | 6 | 0 | | | | Allow NULL? |
| 62 | Serial | Serial Number | int | 11 | 0 | | | | Allow NULL? |
| 63 | SeriesStr | Series String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 64 | SubStr | Subseries String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 65 | AutoWT | Automatic WTax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 66 | WTSum | WTax Amount | num | 19 | 6 | | | | Allow NULL? |
| 67 | WTSumSC | WTax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 68 | WTSumFC | WTax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 69 | WTApplied | Applied WTax | num | 19 | 6 | | | | Allow NULL? |
| 70 | WTAppliedS | Applied WTax (SC) | num | 19 | 6 | | | | Allow NULL? |
| 71 | WTAppliedF | Applied WTax (FC) | num | 19 | 6 | | | | Allow NULL? |
| 72 | BaseAmnt | Base Amount | num | 19 | 6 | | | | Allow NULL? |
| 73 | BaseAmntSC | Base Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 74 | BaseAmntFC | Base Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 75 | BaseVtAt | WTax Base VAT Amount | num | 19 | 6 | | | | Allow NULL? |
| 76 | BaseVtAtSC | WTax Base VAT Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 77 | BaseVtAtFC | WTax Base VAT Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 78 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 79 | BaseTrans | Base Transaction Number | int | 11 | 0 | | | | Allow NULL? |
| 80 | ResidenNum | Residence Number | char | 1 | 0 | | 1 | 1=Spanish Fiscal ID, 2=VAT Registration Number, 3=Passport, 4=Fiscal ID Issued by the Residence Country, 5=Certificate of Fiscal Residence, 6=Other Document | Allow NULL? |
| 81 | OperatCode | Operation Code | char | 1 | 0 | | | A=Summary Invoices Entry, B=Summary Receipts Entry, C=Invoice with Several VAT Rates, D=Correction Invoice, E=Due VAT Pending Invoice Issuance, F=Expenses Incurred by Travel Agent for Customers, G=Special Regulation for VAT Group, H=Special Regulation for Gold Investment, I=Reverse Charge Procedure, J=Unsummarized Receipts, K=Identificatio | Allow NULL? |
