CM_ACCTG_AET(SQL Table) |
Index Back |
|---|---|
CM Accounting State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 6 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 7 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 10 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 11 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 12 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 13 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 14 | DTTM_STAMP_SEC | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 15 | MULTICURRENCY | Character(1) | VARCHAR2(1) NOT NULL | Multi-Currency |
| 16 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 17 | CM_GROUP_SETID | Character(5) | VARCHAR2(5) NOT NULL | Group SetID |
| 18 | SOURCE_BU_SETID | Character(5) | VARCHAR2(5) NOT NULL | Source BU/SETID |
| 19 | SETID_MST_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Master Item SETID |
| 20 | LOC_ACCTG_REQ | Character(1) | VARCHAR2(1) NOT NULL | Location Accounting Required |
| 21 | MG | Character(1) | VARCHAR2(1) NOT NULL | Manufacturing |
| 22 | COMMITMENT_CNTL_IN | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control on IN |
| 23 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid |
| 24 | BUDGET_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
->
SL - 15-AUG-2002
MISC_CRITERIA label has been added
<-
B=Bypass E=Error N=Not Chk'd V=Valid W=Warning |
| 25 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 26 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 27 | CUR_RT_TYPE_DFLT | Character(5) | VARCHAR2(5) NOT NULL | Exchange Rate Type Default |
| 28 | RECNAME1 | Character(15) | VARCHAR2(15) NOT NULL | Record Name 1 |
| 29 | TEMP_VALUE | Character(18) | VARCHAR2(18) NOT NULL | Temporary Query Value |
| 30 | SETCNTRLVALUE_NEW | Character(20) | VARCHAR2(20) NOT NULL | New User Key value for TREE_CHANGE PubSub message |
| 31 | ALTACCT_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Enable Alternate Account |
| 32 | COMMITMENT_CNTL | Character(1) | VARCHAR2(1) NOT NULL | Enable Commitment Control |
| 33 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 34 | CM_PREVIOUS_GRP | Character(3) | VARCHAR2(3) NOT NULL | Previous Transaction Group |
| 35 | RECNAME_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Source Recname |
| 36 | RECNAME_TRANS | Character(18) | VARCHAR2(18) NOT NULL | Selected Transactions |
| 37 | RECNAME_UPDATE | Character(15) | VARCHAR2(15) NOT NULL | Record to Update |
| 38 | CM_DR_LOC_ACCT_OFF | Character(18) | VARCHAR2(18) NOT NULL | CM Dr Definition; Loc Acct Off |
| 39 | CM_DR_LOC_ACCT_ON | Character(18) | VARCHAR2(18) NOT NULL | CM Dr Definition; Loc Acct On |
| 40 | CM_CR_LOC_ACCT_OFF | Character(18) | VARCHAR2(18) NOT NULL | CM Cr Definition; Loc Acct Off |
| 41 | CM_CR_LOC_ACCT_ON | Character(18) | VARCHAR2(18) NOT NULL | CM Cr Definition; Loc Acct On |
| 42 | ADJUST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV |
| 43 | CM_PRIME_TRAN | Character(1) | VARCHAR2(1) NOT NULL | Primary Transaction for Group |
| 44 | CM_COST_PROC_GROUP | Character(18) | VARCHAR2(18) NOT NULL | Cost Flow Record |
| 45 | CM_SOURCE_RECORD | Character(18) | VARCHAR2(18) NOT NULL | CM Transaction Source Record |
| 46 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 47 | CM_RECNAME_UPDATE | Character(15) | VARCHAR2(15) NOT NULL | Record to Update |
| 48 | CM_CF_OVRRID_DR_CR | Character(2) | VARCHAR2(2) NOT NULL |
CM Override DR or CR
CR=Credit DR=Debit |
| 49 | CM_RULE_GROUP | Character(3) | VARCHAR2(3) NOT NULL | Accounting Rule Group |
| 50 | CONS_RULE_GROUP | Character(3) | VARCHAR2(3) NOT NULL | Consignment Rule Group |
| 51 | CM_EXTEND_COST_FLG | Character(1) | VARCHAR2(1) NOT NULL | Extend Cost? |
| 52 | CM_MFG_ONLY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Mfg only transaction? |
| 53 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 54 | SELECT_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Select Clause |
| 55 | SELECT_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Select Clause 2 |
| 56 | FROM_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | From Clause |
| 57 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 58 | CM_CR_ACCT_TBL | Character(18) | VARCHAR2(18) NOT NULL | CR Account |
| 59 | CM_DR_ACCT_TBL | Character(18) | VARCHAR2(18) NOT NULL | Debit Account |
| 60 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 61 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 62 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 63 | ACCTG_LINE_NO | Number(15,0) | DECIMAL(15) NOT NULL | Accounting Line Number |
| 64 | RULE_ORDER | Number(3,0) | SMALLINT NOT NULL | Rule Order |
| 65 | CM_SQL_EXPLODE | Character(18) | VARCHAR2(18) NOT NULL | Explode Table |
| 66 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 67 | POST_OPTION | Character(1) | VARCHAR2(1) NOT NULL | Posting Option |
| 68 | CM_RULE | Number(2,0) | SMALLINT NOT NULL | Accounting Rule Number |
| 69 | DEBIT_CREDIT | Character(2) | VARCHAR2(2) NOT NULL |
Debit / Credit Indicator
CR=Credit DR=Debit |
| 70 | CM_DR_TMP | Character(18) | VARCHAR2(18) NOT NULL | Debit Temp Table |
| 71 | CM_CR_TMP | Character(18) | VARCHAR2(18) NOT NULL | Credit Temp Table |
| 72 | MAX_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Maximum Sequence Number |
| 73 | IU_ANCHOR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields). |
| 74 | CM_IU_ANCHOR | Character(2) | VARCHAR2(2) NOT NULL | GMG added 8/2001. Defines if the Inter/Intra Unit anchor row will be the DR or the CR. |
| 75 | CM_IU_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
IntraUnit Status
B=Balanced E=Error H=Hold for other BU's affiliates I=Ignore N=Not Balanced P=In Process S=Staged X=Balancing Not Required |
| 76 | IU_SYS_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries. |
| 77 | GEN_BAL_ENTRIES | Character(1) | VARCHAR2(1) NOT NULL | IntraUnit Balancing Entries |
| 78 | IU_LEGAL_ENT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use Legal Entity for InterUnit |
| 79 | IU_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Method
D=Direct I=Indirect P=Pairs |
| 80 | IU_ENTRY_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Entry Type
AEAP=IntraEntity Accrued Payable AECG=IntraEntity Cost of Goods AECS=IntraEntity Customer Shipments AEEX=IntraEntity Expense AEPY=IntraEntity Payable AERC=IntraEntity Receivable AERV=IntraEntity Revenue AETR=IntraEntity In Transit AUEX=IntraUnit Expense AUPY=IntraUnit Payable AURC=IntraUnit Receivable AURV=IntraUnit Revenue AUTR=IntraUnit In Transit IEAP=InterEntity Accrued Payable IECG=InterEntity Cost of Goods IECS=InterEntity Customer Shipments IEEX=InterEntity Expense IEPY=InterEntity Payable IERC=InterEntity Receivable IERV=InterEntity Revenue IETR=InterEntity In Transit IUAP=InterUnit Accrued Payable IUCG=InterUnit Cost of Goods IUCS=InterUnit Customer Shipments IUEX=InterUnit Expense IUPY=InterUnit Payable IURC=InterUnit Receivable IURV=InterUnit Revenue IUTR=InterUnit In Transit |
| 81 | IUNIT_VALUES | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Transaction Options
1=Use GL BU Settings Only 2=Use IN BU Settings Only 3=Use Both |
| 82 | CM_ERROR_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Account Line Creation Error
INTR=No InterUnit Rules PROD=No Production Area Rule RULE=No Account Distribution Rule STOR=No Storage Area Rule |
| 83 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |
| 84 | CM_DR_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Debit Rows |
| 85 | CM_CR_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Credit Rows |
| 86 | CM_RULENUM | Number(3,0) | SMALLINT NOT NULL | Rule Number |
| 87 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 88 | CM_UPDATE_STATS | Character(1) | VARCHAR2(1) NOT NULL | Generate Table Statistics |
| 89 | CM_UPDATE_STATS_DE | Character(1) | VARCHAR2(1) NOT NULL | 11/01 mxs |
| 90 | CM_PARALLEL_OK | Character(1) | VARCHAR2(1) NOT NULL | CM_PARALLEL_OK |
| 91 | CE_ITEMCVAR_PSB | Character(1) | VARCHAR2(1) NOT NULL |
Item Variance Table
Default Value: Y |
| 92 | CM_COST_ADJB | Character(1) | VARCHAR2(1) NOT NULL |
Cost Adjustment Table
Default Value: Y |
| 93 | CM_CST_NSSHIPB | Character(1) | VARCHAR2(1) NOT NULL |
Ship Table
Default Value: Y |
| 94 | SF_EARNCONCOSTB | Character(1) | VARCHAR2(1) NOT NULL |
Earned Cost Table
Default Value: Y |
| 95 | SF_SCRAPCOSTB | Character(1) | VARCHAR2(1) NOT NULL |
Scrap Cost Table
Default Value: Y |
| 96 | SF_VARIANCESB | Character(1) | VARCHAR2(1) NOT NULL |
Variance Table
Default Value: Y |
| 97 | AFFILIATE_USE | Character(1) | VARCHAR2(1) NOT NULL | Use Affiliate |
| 98 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 99 | IU_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction. |
| 100 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 101 | WHERE_CLAUSE6 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 102 | SEQUENCE_NO | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 103 | CM_SEQ_PLATFORM_SP | Character(1) | VARCHAR2(1) NOT NULL | Set based Sequencing |
| 104 | CM_PLATFORM | Character(8) | VARCHAR2(8) NOT NULL | Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction. |
| 105 | CM_SEQUENCE_NO_TBL | Character(15) | VARCHAR2(15) NOT NULL | CM_SEQ_NO_TBL |
| 106 | CM_CF_NAME | Character(18) | VARCHAR2(18) NOT NULL | Charfield Name |
| 107 | CM_MIN_ID_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 108 | CM_SET_BASED | Character(1) | VARCHAR2(1) NOT NULL |
Set based Sequencing
1=Use Set Based 2=Row by Row Y/N Table Edit Default Value: N |
| 109 | CM_CF_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 110 | CM_CF_INDEX | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 111 | CM_CF_VALIDATED | Character(1) | VARCHAR2(1) NOT NULL |
CM_CF_VALIDATED
0=Not Validated 1=Valid |
| 112 | CM_DMS_RUN_INST | Character(1) | VARCHAR2(1) NOT NULL | CM_DMS_RUN_STATUS |
| 113 | WHERE_CLAUSE_LONG3 | Long Character(4000) | CLOB | Where Clause |