| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AADM | Administration - Log | 220 | ExpireDate | Expiration Date | Date | 8 | 0 | | |
2 | OADM | Administration | 220 | ExpireDate | Expiration Date | Date | 8 | 0 | | |
TOPBusiness Partners |
3 | ACRD | Business Partners - History | 217 | ExpireDate | Expiration Date | Date | 8 | 0 | | |
4 | OCRD | Business Partner | 217 | ExpireDate | Expiration Date | Date | 8 | 0 | | |
TOPGeneral |
5 | SEWCS | SEWCS | 31 | ExpireDate | Sales - Expiration Date | Date | 8 | 0 | | |
TOPInventory and Production |
6 | IGE26 | Goods Issue - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
7 | IGN26 | Goods Receipt - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
8 | WTQ26 | Inventory Transfer Request - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
TOPMarketing Documents |
9 | ADO26 | Mktg. Docs. - E-Way Bill Information - History | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
10 | CIN26 | Correction Invoice - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
11 | CPI26 | A/P Correction Invoice - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
12 | CPV26 | A/P Correction Invoice Reversal - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
13 | CSI26 | A/R Correction Invoice - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
14 | CSV26 | A/R Correction Invoice Reversal - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
15 | DLN26 | Delivery - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
16 | DPI26 | Down Payment Inv. - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
17 | DPO26 | Down Payment - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
18 | DRF26 | Draft - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
19 | IEI26 | Incoming Excise Invoice - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
20 | INV26 | A/R Invoice - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
21 | OEI26 | Outgoing Excise Invoice - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
22 | PCH26 | A/P Invoice - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
23 | PDN26 | Goods Receipt PO - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
24 | POR26 | Purchase Order - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
25 | PQT26 | Purchase Quotation - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
26 | PRQ26 | Purchase Request - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
27 | PRR26 | A/P Return Request - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
28 | QUT26 | Sales Quotation - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
29 | RDN26 | Returns - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
30 | RDR26 | Sales Order - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
31 | RIN26 | A/R Credit Memo - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
32 | RPC26 | A/P Credit Memo - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
33 | RPD26 | Goods Return - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
34 | RRR26 | A/R Return Request - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
35 | SFC26 | Self Credit Memo - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
36 | SFI26 | Self Invoice - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |
37 | WTR26 | Inventory Transfer - E-Way Bill Information | 32 | ExpireDate | EWB Expiration Date | Date | 8 | 0 | | |