| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | Code | Template Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | Dscription | Description | nvarchar | 50 | 0 | | | | Allow NULL? |
| 4 | IsRemoved | Is Removed | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 5 | DocObjType | Linked Document Type | nvarchar | 20 | 0 | | -1 | -1, -13=A/R Reserve Invoice, -18=A/P Reserve Invoice, -203=A/R Down Payment Request, -204=A/P Down Payment Request, 1250000001=Inventory Transfer Request, 13=A/R Invoice, 1470000113=Purchase Request, 14=A/R Credit Memo, 15=Delivery, 16=Return, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment Invoice, 204=A/P Down Pa | Allow NULL? |
| 6 | DraftEntry | Linked Draft Entry | int | 11 | 0 | ODRF | | | Allow NULL? |
| 7 | Frequency | Frequency | char | 1 | 0 | | M | A=Annually, D=Daily, M=Monthly, O=One Time, Q=Quarterly, S=Semiannually, W=Weekly | Allow NULL? |
| 8 | Remind | Sub-Frequency | int | 6 | 0 | | 1001 | -1, 1001=On 1, 1002=On 2, 1003=On 3, 1004=On 4, 1005=On 5, 1006=On 6, 1007=On 7, 1008=On 8, 1009=On 9, 1010=On 10, 1011=On 11, 1012=On 12, 1013=On 13, 1014=On 14, 1015=On 15, 1016=On 16, 1017=On 17, 1018=On 18, 1019=On 19, 101=Every 1, 1020=On 20, 1021=On 21, 1022=On 22, 1023=On 23, 1024=On 24, 1025=On 25, 1026=On 26, 1027=On 27, 1028=On 2 | Allow NULL? |
| 9 | StartDate | Execution Start Date | date | 8 | 0 | | | | |
| 10 | EndDate | Execution End Date | date | 8 | 0 | | | | |
| 11 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 12 | CreateUser | Created by User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 13 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 14 | CreateTime | Creation Time | int | 6 | 0 | | | | Allow NULL? |
| 15 | UpdateUser | Updated by User | nvarchar | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 17 | UpdateTime | Update Time | int | 6 | 0 | | | | Allow NULL? |
| 18 | DataSource | Data Source | char | 1 | 0 | | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade | Allow NULL? |
| 19 | PriceUpdat | Prices Update | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
