IU_AUDIT_CF_VW(SQL View) |
Index Back |
---|---|
IU CF Value AuditAudit of InterUnit ChartField Values setup |
SELECT DISTINCT IU_FROM_GLBU , IU_TO_GLBU , SETID , BUSINESS_UNIT , IU_INTER_TMPLT_CD , IU_INTRA_TMPLT_CD , SETCNTRLVALUE , SETID2 , CHARTFIELD , CHARTFIELD_VALUE , IU_TRAN_CD , ACT_BAL_GRP , IU_ENTRY_TYPE FROM PS_IU_AUDIT_CF |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | From GL Business Unit | |
2 | Character(5) | VARCHAR2(5) NOT NULL | To GL Business Unit | |
3 | SETID_IU_TEMPLATE | Character(5) | VARCHAR2(5) NOT NULL | Template Setid |
4 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
5 | Character(5) | VARCHAR2(5) NOT NULL | Key to the interunit template record. Assigned to a GLBU on the GL business unit table. | |
6 | Character(5) | VARCHAR2(5) NOT NULL | Key field for IntraUnit Template | |
7 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
8 | SETID_IU_CF | Character(5) | VARCHAR2(5) NOT NULL | ChartField Setid |
9 | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). | |
10 | IU_CF_VALUE | Character(30) | VARCHAR2(30) NOT NULL | ChartField Value |
11 | 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. | |
12 | Character(10) | VARCHAR2(10) NOT NULL | Account Balancing Group | |
13 | 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 |