GL Remote Transfer
This file is used to collect General Ledger and Activity transactions from a
remote site machine. This file is populated by transferring the General Ledger
transaction CSV file from the remote site into this database file for
processing on this target machine.
UPDATED BY
GL311 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
GTX-MACHINE-CODE Element: Machine Code | Alpha 12 Designates a code name associated with a particular machine in a multiple machine environment. |
|
|
GTX-OBJ-ID Element: Obj ID | Numeric 12 This is the transaction identifier. It is used to keep a record unique from other records originating from the same Machine Code. |
|
|
GTX-SYSTEM Element: System | Alpha 2 A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.) |
|
|
GTX-PROGRAM Element: Program | Alpha 5 Designates the program this record was created by. |
|
|
GTX-SUMMARIZE Element: Summarize | Alpha 1 Determines whether transactions should be summarized to the General Ledger or if one General Ledger transaction should be created for each record in this file. Y = Summarize N = Detail |
|
|
GTX-COMPANY Element: Company | Numeric 4 The company number as defined in GL10.1 (Company). |
|
|
GTX-POSTING-DATE Element: Posting Date | Numeric 8 (yyyymmdd) The date assigned to the journal entry for posting. |
|
|
GTX-ZONE-ACCTUNIT Element: Zone Accounting Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
|
GTX-CNTRL-DOCUMENT Element: Control Document | Alpha 27 This is the Document Number used to group transactions into the same Journal Entry if Journal by Document is selected. |
|
|
GTX-JRNL-BOOK-NBR Element: Journal Book Number | Alpha 12 The journal book assigned to the transaction. |
|
|
GTX-JE-TYPE Element: Journal Entry Type | Alpha 1 The type of journal entry. Valid values are Normal or Intercompany. N = Normal I = Intercompany |
|
|
GTX-TO-COMPANY Element: To Company | Numeric 4 This is the company number a line is posted to. |
|
|
GTX-SOURCE-CODE Element: Source Code | Alpha 2 A two-character code assigned to a transaction to identify where the transaction was created. |
|
|
GTX-ACCT-UNIT Element: Accounting Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
|
GTX-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
|
GTX-SUB-ACCOUNT Element: Subaccount | Numeric 4 This field along with the accounting unit and account make up the location (account) where amounts and other account information are stored. |
|
|
GTX-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
|
GTX-ACCT-CATEGORY Element: Account Category | Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru |
|
|
GTX-CURRENCY-CODE Element: Currency Code | Alpha 5 This identifies the company base currency code as defined in CU01.1 (Currency Code). |
|
|
GTX-DATE Element: Date | Numeric 8 (yyyymmdd) This field contains the system date the record was created. |
|
|
GTX-SUMMARY-CNTRL Element: Summary Control | Alpha 20 This field provides a break down of transaction summarization's to a finer level of detail. Two transactions with different Summary Control values will not be summarized. |
|
|
GTX-AUTO-REV Element: Auto Rev | Alpha 1 When the Auto Reversal field is set to "Y," the Lawson General Ledger Closing program GL199 creates an opposite entry for this transaction in the next period. |
|
|
GTX-ANALYSIS-FLD Element: Analysis Field | Alpha 32 Occurs 3 Times The user-defined analysis field assigned to the transaction based on the transaction's source code. |
|
|
GTX-SIGN Element: Sign | Alpha 1 Indicates the sign type. 0 = Negative Sign 1 = Positive Sign |
|
|
GTX-RESOURCE-TYPE Element: Resource Type | Alpha 1 Indicates whether the resource is a person or equipment. |
|
|
GTX-RESOURCE Element: Resource | Alpha 10 This is the resource description. |
|
|
GTX-FORCE-DETAIL Element: Force Detail | Alpha 1 Determines whether this individual transaction can be summarized along with other like transactions. Y = Detail A = Sign Summary " " = Summarize |
|
|
GTX-REFERENCE Element: Reference | Alpha 10 (Lower Case) The reference number associated with the transaction. |
|
|
GTX-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The reference description. |
|
|
GTX-DOCUMENT-NBR Element: Document Number | Alpha 27 The document number assigned to the transaction. |
|
|
GTX-BASE-AMOUNT Element: Base Amount | Signed 18.2 The base amount to be posted to the General Ledger Master file. |
|
|
GTX-BASE-ND Element: Base ND | Numeric 1 The number of decimal positions defined for the company base currency. |
|
|
GTX-BASERATE Element: Base Rate | Signed 14.7 The exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default. |
|
|
GTX-TO-BASE-AMT Element: To Base Amount | Signed 18.2 This is the To Company's base currency amount. |
|
|
GTX-TO-BASE-ND Element: To Base ND | Numeric 1 This is the To Company's base currency number of decimals. |
|
|
GTX-TO-BASERATE Element: To Base Rate | Signed 14.7 This is the Exchange Rate used to convert the transaction's currency amount to the To Company's Base Currency. |
|
|
GTX-TRAN-AMOUNT Element: Tran Amount | Signed 18.2 |
|
|
GTX-TRAN-ND Element: Tran ND | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
|
GTX-ACCT-CURRENCY Element: Account Currency | Alpha 5 This is the base currency of the General Ledger account number. |
|
|
GTX-ACCT-AMOUNT Element: Account Amount | Signed 18.2 This is the amount of the transaction in the General Ledger account's base currency. |
|
|
GTX-ACCT-RATE Element: Account Rate | Signed 14.7 This is the Exchange Rate used to convert the transaction currency to the General Ledger account's base currency. |
|
|
GTX-ACCT-ND Element: Account ND | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
|
GTX-UNITS-AMOUNT Element: Units Amount | Signed 15.2 The units amount of the transaction. |
|
|
GTX-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) This is the date the transaction is effective for Average Daily Balance. |
|
|
GTX-PROGRAM-INFO Element: Program Info | Alpha 100 This field contains the keys to the record from the originating file. |
|
|
GTX-SEGMENT-BLOCK Element: Segment Block | Alpha 103 This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information. |
|
|
GTX-RPT-AMOUNT-1 Element: Intl Amt | Signed 18.2 |
|
|
GTX-RPT-RATE-1 Element: Curr Rate | Signed 14.7 The currency rate. |
|
|
GTX-RPT-ND-1 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
|
GTX-RPT-AMOUNT-2 Element: Intl Amt | Signed 18.2 |
|
|
GTX-RPT-RATE-2 Element: Curr Rate | Signed 14.7 The currency rate. |
|
|
GTX-RPT-ND-2 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
|
GTX-RESOURCE-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
GTXSET1 |
MACHINE-CODE OBJ-ID |
|
|||||||||
GTXSET2 |
MACHINE-CODE SYSTEM PROGRAM SUMMARIZE OBJ-ID COMPANY |
|
|
All trademarks and registered trademarks are the property of their
respective owners.