Currency Amount-Daily
The Daily Report Currency (CUAMOUNTX) file stores daily account balances for report currencies.
REFERENCED BY
GLOP.1 | GL243 | GL43.1 |
GL110 | GL120 | GL146 | GL148 | GL167 | GL190 |
GL197 | GL300 | GL310 | GL328 | GL40.1 | GL40.2 |
GL40.3 | GL40.7 | GL40.8 | GL44.1 | GL45.1 | GL500 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CAX-COMPANY Element: Company | Numeric 4 The company number assigned to the report currencies in GL10.1 (Company). |
|
||||||||||||||
CAX-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this reocrd was created. |
|
||||||||||||||
CAX-AMT-TYPE Element: Amt Type | Numeric 1 The amount type indicates whether the record is currency one or currency two. 3 = Currency One Balance 4 = Currency Two Balance |
|
||||||||||||||
CAX-VAR-LEVELS Element: Var Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||||
CAX-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. |
|
||||||||||||||
CAX-SUB-ACCOUNT Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||||||||||
CAX-ACCT-UNIT Element: Acct 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. |
|
||||||||||||||
CAX-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||
CAX-CHART-NAME Element: Chart Name | Alpha 12 This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system. |
|
||||||||||||||
CAX-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||
CAX-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||||||||||||
CAX-DB-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||
CAX-CR-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||
CAX-BASE-DB-AMT Element: Intl Amt | Signed 18.2 The base currency debit amount. |
|
||||||||||||||
CAX-BASE-CR-AMT Element: Intl Amt | Signed 18.2 The base currency credit amount. |
|
||||||||||||||
CAX-ACCT-PERIOD Element: Acct Period | Numeric 2 This is the current accounting period. This field is updated by GL199 (Period Closing). |
|
||||||||||||||
CAX-FISCAL-YEAR Element: Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||||||||||||||
CAX-MAINT-DATE Element: Maint Date | Numeric 8 (yyyymmdd) The date last changed. |
|
||||||||||||||
CAX-MAINT-TIME Element: Sys Time | Numeric 6 (hhmmss) |
|
||||||||||||||
CAX-NET-AMOUNT Element: Net Amount | Derived The net daily report currency amount. This amount is the debit amount added to the credit amount. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CAXSET1 |
COMPANY AMT-TYPE DATE ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||||
CAXSET3 |
COMPANY AMT-TYPE FISCAL-YEAR ACCT-UNIT ACCOUNT SUB-ACCOUNT DATE |
|
| ||||||||||||||||||||||||
CAXSET4 |
COMPANY AMT-TYPE ACCT-UNIT ACCOUNT SUB-ACCOUNT DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Gltrans | GLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.