| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 3 |
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).
|
| 4 |
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.
|
| 5 |
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.
|
| 6 |
CF_INHERIT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: CF_INHERIT_TBL.CF_INHERIT_GRP.SearchInit
APCA=Payables Header Level Entries
APEA=Payables Distrib Level Entries
APPE=Payables Period End Accruals
APVN=Payables VAT Non-Recoverable
ARBI=Receivables and Billing
ARRE=Receivables Revaluation
DMAC=Deduction Management Accounts
EXCA=Expenses Control Accounts
EXCR=Expenses Cash Advance Recon
EXPY=Expenses Payroll Offset
EXVN=Expenses VAT Non-Recoverable
GLVI=GL Journal VAT Input Other
GLVN=GL Journal VAT Non-Recoverable
GLVO=GL Journal VAT Output
POCA=Purchasing Control Accounts
POEA=Purchasing Expense Accounts
POVN=Purchasing VAT Non-Recoverable
TDAC=Promotions Mgmt. Accounts
TRVI=Treasury VAT Input Other
TRVN=Treasury VAT Non-Recoverable
TRVO=Treasury VAT Output
|
| 7 |
EX_CF_INH_OBJ |
Character(254) |
VARCHAR2(254) NOT NULL |
Chartfield Inherit SQL Object
|
| 8 |
INSERT_BU_EQ |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause for Equal BU
|
| 9 |
INSERT_BU_NEQ |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert BU's Not Equal
|
| 10 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 11 |
SETID_SELECT_SQL |
Character(254) |
VARCHAR2(254) NOT NULL |
Setid Select SQL
|
| 12 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 13 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 14 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 15 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross Up Indicator
|
| 16 |
RECORDNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC
|
| 17 |
SKIP_VAT_PROC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip VAT Applicable Processing
Default Value: N
|