| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | ObjectCode | Document | nvarchar | 20 | 0 | | | | Allow NULL? |
| 2 | AutoKey | Automatic Key | int | 11 | 0 | | 0 | | Allow NULL? |
| 3 | DfltSeries | Default Series | int | 11 | 0 | | 0 | | Allow NULL? |
| 4 | UpdCounter | Update Counter | int | 6 | 0 | | 0 | | Allow NULL? |
| 5 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 6 | DocSubType | Document Sub-Type | nvarchar | 2 | 0 | | -- | --, DM=A/P Debit Memo, DN=Debit Memo, EB=Exempt Bill, GA=GST Tax Invoice, GD=GST Debit Memo, IB=Bill, IC=Incoming WTax Certificate, IE=Invoice Exempt, IR=Invoice & Receipt, IX=Export Invoice, OD=Outgoing District Specific - Withholding Tax, OG=Outgoing Gross Income - Withholding Tax, OI=Outgoing Industry Specific - Withholding Tax, ON=Outg | Allow NULL? |
| 7 | DocAlias | Alternative Document Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 8 | PeriodTyp | Seq. Period Type of Supply Code | char | 1 | 0 | | | | Allow NULL? |