Importing Offset Account Assignments
The following table defines the field references to be used in the Offset Account Assignments section of the MasterGL.DEF file:
| Table: tblOffsetAssign | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,OFFSET,HEADER,HOFFST | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
OFFSET_TRANSID |
Y |
3 |
Transaction Source Codes: APC, API, ARB, ARC, CD, CR, or JV. See Table 1. |
|
|
OFFSET_ |
Y |
User Defined |
Transaction entry (TE) fund. Required if organization has Fund segment. |
|
|
OFFSET_ |
Y |
User Defined |
TE GL Code |
|
|
OFFSET_ |
Y* |
3 |
Active or inactive Currency code. *Required for APC and ARC transaction source codes. |
|
|
OFFSET_OFFSETFUND |
Y |
User Defined |
Automatic Offset Fund. Required if organization has Fund segment. |
|
|
OFFSET_OFFSETGL |
Y |
User Defined |
Automatic Offset GL Code |
|
|
OFFSET_TRIGGERIF |
Y* |
User Defined |
Interfund account used for TE fund. *Required if TE fund is different than offset fund. |
|
|
OFFSET_OFFSETIF |
Y* |
User Defined |
Interfund account used for auto offset. *Required if TE fund is different than auto offset fund. |
|