| 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
|
|
|
|
|