A_CHARGE_ACCOUNT_MASTER
ARCHIVED CHARGE ACCOUNT MODULE - MASTER DATABASE TABLE
tableMANCHARGE
A_CHARGE_ACCOUNT_MASTER — ARCHIVED CHARGE ACCOUNT MODULE - MASTER DATABASE TABLE. MAN table in the standard Ross ERP 8.0 schema: 41 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.
Open A_CHARGE_ACCOUNT_MASTER in the interactive Data Dictionary →Part of Other tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | ARCHIVE_ID | varchar(1) | PK | Prefix Fields for Archive Tables |
| 3 | CAM_OWN_ID | varchar(12) | Company/Factory Id | |
| 4 | CAM_ACCT_ID | varchar(20) | PK | Charge Account Id |
| 5 | CAM_ACCT_NM | varchar(40) | Charge Account Name | |
| 6 | CAM_DPT_ID | varchar(5) | Department Id | |
| 7 | CAM_CAT_ID | varchar(2) | Category Id | |
| 8 | CAM_CLS_ID | varchar(2) | Classification Id | |
| 9 | CAM_STAT | varchar(1) | Charge Account Status | |
| 10 | CAM_STAT_DTE | datetime | Date Charge Account Status Changed | |
| 11 | CAM_STAT_UID | varchar(16) | User Id Who Changed Charge Account Status | |
| 12 | CAM_FCST_LBR | numeric(20,4) | Charge Account Forecast (Budget) Labor Cost | |
| 13 | CAM_FCST_DTE | datetime | Charge Account Forecast (Budget) Date | |
| 14 | CAM_FCST_MATL | numeric(20,4) | Charge Account Forecast (Budget) Material Cost | |
| 15 | CAM_DSC1 | varchar(50) | Charge Account Description - Line 1 | |
| 16 | CAM_DSC2 | varchar(50) | Charge Account Description - Line 2 | |
| 17 | CAM_DSC3 | varchar(50) | Charge Account Description - Line 3 | |
| 18 | CAM_DSC4 | varchar(50) | Charge Account Description - Line 4 | |
| 19 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 20 | INS_DTE | datetime | Date of Row Insertion | |
| 21 | INS_TME | varchar(4) | Time of Row Insertion | |
| 22 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 23 | FACTORY_CODE | varchar(2) | PK | Factory Code |
| 24 | MM_PROJECT_ID | varchar(10) | Project | |
| 25 | GL_SUSPENSE_ACCOUNT | varchar(50) | Suspense Holding | |
| 26 | GL_LABOUR_ACCOUNT | varchar(50) | Employee Labor | |
| 27 | GL_LABOUR_CODE | varchar(6) | Employee Labor Code | |
| 28 | GL_CONTRACTOR_ACCOUNT | varchar(50) | Contract Labor | |
| 29 | GL_CONTRACTOR_CODE | varchar(6) | Contractor Labor Code | |
| 30 | GL_INV_ACCOUNT | varchar(50) | Gl Inventory Account | |
| 31 | GL_INV_CODE | varchar(6) | GL Code Inventory | |
| 32 | GL_NONSTOCKED_ACCOUNT | varchar(50) | Non-Stocked Parts | |
| 33 | MM_CAPITALIZE | varchar(1) | Capitalize | |
| 34 | MM_TAXABLE | varchar(1) | Taxable | |
| 35 | MM_FUNDING_SOURCE | text | Funding Sources | |
| 36 | AUTHORIZATION_CODE | varchar(6) | Authorization Code | |
| 37 | GL_NONSTOCKED_CODE | varchar(6) | Nonstocked Parts Code | |
| 38 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status | |
| 39 | ARCHIVE_DATE | datetime | Archive Date | |
| 40 | ARCHIVE_USERNAME | varchar(20) | Username recorded when the row was moved to the archive. | |
| 41 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |