CM_ACCT_SRT_TMP(SQL Table) |
Index Back |
|---|---|
Inv Accting Sort Temp RecordRecords will be written to this table during the Inventory Value Report generation if the user chooses to sort by account. The records will be cleared from this table after the report is run. 02/04/99 ej CN#CM800-2.0 : UNIT_COST_LND added for Landed Cost Enhancement KDN CM800-7.1: Added ALTACCT field. 08/09/1999 whs CM800-17.0: Added CONSIGN_FLAG 02/18 dmw Bundle:4183 Res: 152675 ICE:654962000 & 644681000 Added process_instance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 3 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 7 | CM_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
8/20/02 lee: added xlate 9 for retroactive perp average
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost 1=Actual Cost 6=Perpetual Weighted Average 7=Periodic Weighted Average 8=Value at Current Standard 9=Retroactive Perpetual Average |
| 8 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 9 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL | Family |
| 10 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 11 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 12 | UNIT_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost |
| 13 | UNIT_COST_MAT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Material |
| 14 | UNIT_COST_INB | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Inbound |
| 15 | UNIT_COST_CON | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Conversion |
| 16 | UNIT_COST_COH | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Conversion Ovrhead |
| 17 | UNIT_COST_OUB | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Outbound |
| 18 | UNIT_COST_LND | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | 02/04/99 ej CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 19 | UNIT_COST_OTH | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Other |
| 20 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 21 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 22 | COST_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
1/12/99 ebn CN#CM800-2.0 : Added Landed Cost translate value
ATC=Addl Trans COH=Con Ovhd CON=Conversion INB=Inbound LND=Landed MAT=Material OTH=Other OUB=Outbound |
| 23 | XFR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Flag
Y/N Table Edit |
| 24 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 25 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |