| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | ObjectCode | Document | nvarchar | 20 | 0 | | | | Allow NULL? |
| 2 | SeqCode | Seq. Code | int | 6 | 0 | | 0 | | Allow NULL? |
| 3 | SeqName | Seq. Name | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | InitialNum | Initial Number | int | 11 | 0 | | 0 | | Allow NULL? |
| 5 | NextNum | Next Number for Use | int | 11 | 0 | | 0 | | Allow NULL? |
| 6 | LastNum | Last Number Allowed | int | 11 | 0 | | | | Allow NULL? |
| 7 | SeriesStr | Series String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | SubStr | Subseries String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | Remark | Remarks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 10 | GroupCode | Group | int | 6 | 0 | | 1 | 1, 10, 2, 3, 4, 5, 6, 7, 8, 9 | Allow NULL? |
| 11 | Locked | Locked | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 12 | YearTransf | Year-End Closing | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 13 | Indicator | Period Indicator | nvarchar | 10 | 0 | OPID | | | Allow NULL? |
| 14 | Template | Template | nvarchar | 20 | 0 | | | | Allow NULL? |
| 15 | NumSize | Numeric Size | int | 11 | 0 | | | | Allow NULL? |
| 16 | Prefix | Prefix | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | Suffix | Suffix | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | DocSubType | Document Sub-Type | nvarchar | 2 | 0 | | -- | | Allow NULL? |
| 19 | Model | Nota Fiscal Model | nvarchar | 10 | 0 | | 0 | 0, 10=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=NF Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F, 36=Mode | Allow NULL? |
| 20 | Location | Location Code | int | 11 | 0 | OLCT | | | Allow NULL? |