Attributes - INVSALOD - Sales |
|
|
|
|
|
|
|
|
Relational |
Transaction |
INVSLDOD |
ToAll |
Serial |
Yes |
Yes |
Emptied |
Field-by-Field |
|
|
|
Len
| Dec
| |
|
|
|
|
|
1
| Voucher
| C
| 8
|
| No
|
|
| Voucher
| Serial.Pk
| INVSLDOD
|
2
| Date
| D
| 8
|
|
|
|
| Date
| TransDate
|
|
3
| Invoice
| C
| 8
|
| No
|
|
| Invoice
|
|
|
4
| CustCode
| C
| 8
|
|
|
|
| ID_Custm
|
| V_CUSTOM
|
5
| CustomerName
| C
| 35
|
|
|
|
|
|
|
|
6
| City
| C
| 15
|
|
|
|
| City
|
|
|
7
| Debit
| C
| 8
|
|
|
|
| ID_Accnt_D
|
| V_LEDGER
|
8
| Territory
| C
| 3
|
|
|
|
| Territory
|
|
|
9
| TypeSale
| C
| 8
|
|
|
|
| TypeSale
|
| V_TYSALE
|
10
| Credit
| C
| 8
|
|
|
|
| ID_Accnt_C
|
| V_LEDGER
|
11
| <OrdChln>
| C
| 9
|
|
|
| Yes
|
| TabField
|
|
12
| OrderIds
| C
| 104
|
| No
|
| Yes
|
|
|
|
13
| DlvryChallns
| C
| 107
|
| No
|
| Yes
|
|
|
|
14
| Use_It_Anyway
| C
| 60
|
|
| Yes
| Yes
|
|
|
|
15
| Store
| C
| 8
|
|
|
| Yes
|
|
|
|
16
| <Ref>
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
17
| Ref_1
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
18
| Ref_2
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
19
| Ref_3
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
20
| Ref_4
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
21
| RLst
| N
| 2
|
|
|
|
|
|
|
|
22
| <InSight>
| C
| 9
|
|
|
|
|
| TabField
|
|
23
| Units
| N
| 8
|
|
|
|
|
|
|
|
24
| Quantity
| N
| 10
| 3
|
|
|
|
|
|
|
25
| Amt_1
| N
| 12
| 2
|
|
|
|
|
|
|
26
| Amt_2
| N
| 12
| 2
|
|
|
|
|
|
|
27
| Amt_3
| N
| 12
| 2
|
|
|
|
|
|
|
28
| Amt_4
| N
| 13
| 4
|
|
|
|
|
|
|
29
| GrossSales
| N
| 17
| 2
|
|
|
|
|
|
|
30
| < A >
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
31
| %_A_1
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
32
| Charge_A_1
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
33
| %_A_2
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
34
| Charge_A_2
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
35
| %_A_3
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
36
| Charge_A_3
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
37
| %_A_4
| N
| 10
| 3
|
| Yes
| Yes
|
|
|
|
38
| Charge_A_4
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
39
| <Dsc>
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
40
| %_Dis_T
| N
| 5
| 2
|
| Yes
| Yes
|
|
|
|
41
| Trd_Disc
| N
| 10
| 2
|
| Yes
| Yes
|
|
|
|
42
| %_Dis_C
| N
| 5
| 2
|
| Yes
| Yes
|
|
|
|
43
| Cash_Disc
| N
| 10
| 2
|
| Yes
| Yes
|
|
|
|
44
| %_Dis_S
| N
| 5
| 2
|
| Yes
| Yes
|
|
|
|
45
| Spl_Disc
| N
| 10
| 2
|
| Yes
| Yes
|
|
|
|
46
| < B >
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
47
| %_B_1
| N
| 10
| 3
|
| Yes
| Yes
|
|
|
|
48
| Charge_B_1
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
49
| %_B_2
| N
| 10
| 3
|
| Yes
| Yes
|
|
|
|
50
| Charge_B_2
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
51
| %_B_3
| N
| 10
| 3
|
| Yes
| Yes
|
|
|
|
52
| Charge_B_3
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
53
| %_B_4
| N
| 10
| 3
|
| Yes
| Yes
|
|
|
|
54
| Charge_B_4
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
55
| <Tax>
| C
| 5
|
|
|
|
|
| TabField
|
|
56
| TaxableAmount
| N
| 17
| 2
|
| Yes
| Yes
|
|
|
|
57
| %_Tax
| N
| 5
| 2
|
| Yes
|
|
|
|
|
58
| Tax
| N
| 17
| 2
|
| Yes
|
|
|
|
|
59
| %_Sur
| N
| 5
| 2
|
| Yes
|
|
|
|
|
60
| Surcharge
| N
| 8
| 2
|
| Yes
|
|
|
|
|
61
| < C >
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
62
| %_C_1
| N
| 7
| 3
|
| Yes
| Yes
|
|
|
|
63
| Charge_C_1
| N
| 10
| 2
|
| Yes
| Yes
|
|
|
|
64
| Charge_C_2
| N
| 14
| 4
|
| Yes
| Yes
|
|
|
|
65
| %_C_2
| N
| 7
| 3
|
| Yes
| Yes
|
|
|
|
66
| Charge_C_3
| N
| 10
| 2
|
| Yes
| Yes
|
|
|
|
67
| Charge_C_4(+)
| N
| 14
| 4
|
| Yes
| Yes
|
|
|
|
68
| %_C_3
| N
| 7
| 3
|
| Yes
| Yes
|
|
|
|
69
| Charge_C_5(+)
| N
| 14
| 4
|
| Yes
| Yes
|
|
|
|
70
| Charge_C_6
| N
| 14
| 4
|
| Yes
| Yes
|
|
|
|
71
| Charge_C_7
| N
| 10
| 2
|
| Yes
| Yes
|
|
|
|
72
| AdjustAmt(-)
| N
| 10
| 2
|
| Yes
| Yes
|
|
|
|
73
| %_C_4
| N
| 10
| 3
|
| Yes
| Yes
|
|
|
|
74
| Charge_C_8
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
75
| Round?
| L
| 1
|
|
| Yes
| Yes
|
|
|
|
76
| RoundRs
| N
| 8
| 2
|
|
| Yes
|
|
|
|
77
| NetAmount
| N
| 17
| 2
|
| Yes
|
|
|
|
|
78
| <Tpt>
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
79
| Transport
| C
| 8
|
|
| Yes
| Yes
| ID_Trnsp
|
| V_TRANSP
|
80
| Vehicle_No
| C
| 14
|
|
| Yes
| Yes
|
|
|
|
81
| GR_No
| C
| 16
|
|
| Yes
| Yes
|
|
|
|
82
| GR_Date
| D
| 8
|
|
| Yes
| Yes
|
|
|
|
83
| Packages
| N
| 10
|
|
| Yes
| Yes
|
|
|
|
84
| Freight
| N
| 10
| 2
|
| Yes
| Yes
|
|
|
|
85
| Mark
| C
| 16
|
|
| Yes
| Yes
|
|
|
|
86
| Weight
| N
| 10
| 3
|
| Yes
| Yes
|
|
|
|
87
| Transprt
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
88
| Tpt_Info
| C
| 16
|
|
| Yes
| Yes
|
|
|
|
89
| <Mis>
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
90
| Agent
| C
| 8
|
|
| Yes
| Yes
| ID_Agent
|
| AGENTS
|
91
| Bankers
| C
| 8
|
|
| Yes
| Yes
|
|
| V_BANKER
|
92
| DueDate
| D
| 8
|
|
| Yes
| Yes
| DueDate
|
|
|
93
| AmtReceived
| N
| 14
| 2
|
|
|
|
|
|
|
94
| Agent_2
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
95
| Fig_3
| N
| 14
| 3
|
| Yes
| Yes
|
|
|
|
96
| YsNo_5
| L
| 1
|
|
| Yes
| Yes
|
|
|
|
97
| Dte_0
| D
| 8
|
| No
|
| Yes
|
|
|
|
98
| Mis_Ref
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
99
| Num_A
| N
| 14
| 2
|
| Yes
| Yes
|
|
|
|
100
| <Frm>
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
101
| Form?
| L
| 1
|
|
|
| Yes
|
|
|
|
102
| Form_Rs
| N
| 14
| 2
|
| Yes
| Yes
|
|
|
|
103
| Form_No
| C
| 16
|
|
|
| Yes
|
|
|
|
104
| <Gvt>
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
105
| Time_I
| C
| 5
|
|
|
| Yes
|
|
|
|
106
| Date_Rmv
| D
| 8
|
|
|
| Yes
|
|
|
|
107
| Time_R
| C
| 5
|
|
|
| Yes
|
|
|
|
108
| GvtAcc_1
| C
| 8
|
|
| Yes
| Yes
|
|
| EX_MASTR
|
109
| Acc_1_No
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
110
| Acc_1_Amt
| N
| 12
| 2
|
| Yes
| Yes
|
|
|
|
111
| GvtAcc_2
| C
| 8
|
|
| Yes
| Yes
|
|
| EX_MASTR
|
112
| Acc_2_No
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
113
| Acc_2_Amt
| N
| 15
| 4
|
| Yes
| Yes
|
|
|
|
114
| GvtAcc_3
| C
| 8
|
|
| Yes
| Yes
|
|
| EX_MASTR
|
115
| Acc_3_No
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
116
| Acc_3_Amt
| N
| 12
| 2
|
| Yes
| Yes
|
|
|
|
117
| GvtAcc_4
| C
| 8
|
|
| Yes
| Yes
|
|
| EX_MASTR
|
118
| Acc_4_No
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
119
| Acc_4_Amt
| N
| 15
| 4
|
| Yes
| Yes
|
|
|
|
120
| GvtAcc_5
| C
| 8
|
|
| Yes
| Yes
|
|
| EX_MASTR
|
121
| Acc_5_No
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
122
| Acc_5_Amt
| N
| 12
| 2
|
| Yes
| Yes
|
|
|
|
123
| GvtAcc_6
| C
| 8
|
|
| Yes
| Yes
|
|
| EX_MASTR
|
124
| Acc_6_No
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
125
| Acc_6_Amt
| N
| 12
| 2
|
| Yes
| Yes
|
|
|
|
126
| <Gen>
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
127
| Dte_1
| D
| 8
|
|
| Yes
| Yes
|
|
|
|
128
| YNo_1
| L
| 1
|
|
| Yes
| Yes
|
|
|
|
129
| Inf_1
| C
| 70
|
|
| Yes
| Yes
|
|
|
|
130
| Inf_2
| C
| 70
|
|
| Yes
| Yes
|
|
|
|
131
| Inf_3
| C
| 70
|
|
| Yes
| Yes
|
|
|
|
132
| Inf_4
| C
| 70
|
|
| Yes
| Yes
|
|
|
|
133
| Inf_5
| C
| 70
|
|
| Yes
| Yes
|
|
|
|
134
| Inf_6
| C
| 70
|
|
| Yes
| Yes
|
|
|
|
135
| Inf_7
| C
| 70
|
|
| Yes
| Yes
|
|
|
|
136
| Dte_6
| D
| 8
|
|
| Yes
| Yes
|
|
|
|
137
| Dte_7
| D
| 8
|
|
| Yes
| Yes
|
|
|
|
138
| Dte_8
| D
| 8
|
|
| Yes
| Yes
|
|
|
|
139
| Dte_9
| D
| 8
|
|
| Yes
| Yes
|
|
|
|
140
| <Xpo>
| C
| 5
|
|
|
| Yes
|
| TabField
|
|
141
| Consignee
| C
| 8
|
|
| Yes
| Yes
|
|
| X_CUSTOM
|
142
| Notify
| C
| 8
|
|
| Yes
| Yes
|
|
| X_CUSTOM
|
143
| Agent
| C
| 8
|
|
| Yes
| Yes
|
|
| X_CUSTOM
|
144
| Banker
| C
| 8
|
|
| Yes
| Yes
|
|
| X_CUSTOM
|
145
| PortDschrg
| C
| 15
|
|
| Yes
| Yes
|
|
| CITIES
|
146
| PortDstntn
| C
| 15
|
|
| Yes
| Yes
|
|
| CITIES
|
147
| DlvTerms
| C
| 8
|
|
| Yes
| Yes
|
|
| X_DLVTRM
|
148
| PayTerms
| C
| 8
|
|
| Yes
| Yes
|
|
| X_PAYTRM
|
149
| PreCarer
| C
| 8
|
|
| Yes
| Yes
|
|
| X_SHPMOD
|
150
| ShpCarer
| C
| 8
|
|
| Yes
| Yes
|
|
| X_SHPMOD
|
151
| LtrCredt
| C
| 8
|
|
| Yes
| Yes
|
|
| X_NLC
|
152
| Currency
| C
| 8
|
|
| Yes
| Yes
|
|
|
|
|