Importing Charge Codes
Multicurrency Users
The following tables define field references used in the Charge Codes section of the MasterAB.DEF file:
Header
| Table: tblARChargeCode | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,CHARGECODE,HEADER,HCHCOD | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
CHARGECODE_ID |
Y |
User Defined |
Charge Code |
|
|
CHARGECODE_ |
Y |
1 |
A |
A (Active), I (Inactive), or D (Discontinued) |
|
CHARGECODE_ |
Y |
User Defined |
Code Description |
|
|
CHARGECODE_ |
N |
3 |
functional currency |
Active or inactive Currency code. |
|
CHARGECODE_ |
Y |
User Defined |
GL (Revenue) Account |
|
|
CHARGECODE_ |
Y |
12 |
Distribution Code |
|
|
CHARGECODE_ |
N |
User Defined |
Optional Charge Code Designation |
|
|
CHARGECODE_ |
N |
1 |
0 |
0 = No; 1 = Yes |
|
CHARGECODE_ |
N |
1 |
0 |
0 = No; 1 = Yes |
|
CHARGECODE_ |
N |
1 |
N |
N (Non-Inventory Related) |
|
CHARGECODE_ |
N |
5 |
Cost of Goods Sold General Ledger Account. |
|
|
CHARGECODE_ |
N |
12 |
Related Item Code. |
|
|
CHARGECODE_ |
Y |
2 |
FA, FP, VC, AV, PA, or VP. See Table 3. |
|
|
CHARGECODE_ |
N |
Currency |
0.00 |
Required for FA and FP. See Table 3. |
|
CHARGECODE_ |
N |
18 |
0.00 |
Required for VP and AV. See Table 3. |
|
CHARGECODE_ |
N |
8 |
Required for PA |
|
|
CHARGECODE_ |
N |
25 |
Required for PA |
|
Detail
| Table: tblARChargeCodeCalculation | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,CHARGECODE,DETAIL,DCHCOD | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
CCPL_CHARGECODE |
Y |
User Defined |
Charge Code |
|
|
CCPL_LINENUM |
N |
Integer |
Order line items are listed. |
|
|
CCPL_FIXEDCHARGE |
Y |
Currency |
0.00 |
Required for VP. See Table 3. |
|
CCPL_UNITPRICE |
Y |
Currency |
0.00 |
Required for VP and AV. See Table 3. |
|
CCPL_MAXUNITS |
Y |
4 |
0.00 |
Required for VP and AV. See Table 3. |