PeopleSoft 9.0
Cash Management

Table Name PENDING_ITEM

Table Description
PENDING_ITEM
Columns
Name Datatype Is PK Is FK
GROUP_BU CHAR(5) Yes No
GROUP_ID CHAR(15) Yes No
BUSINESS_UNIT CHAR(5) Yes No
CUST_ID CHAR(15) Yes No
ITEM CHAR(30) Yes No
ITEM_LINE INT Yes No
GROUP_SEQ_NUM INT Yes No
ENTRY_TYPE CHAR(5) No No
ENTRY_REASON CHAR(5) No No
ENTRY_AMT DECIMAL(26,3) No No
ENTRY_EVENT CHAR(10) No No
ACCOUNTING_DT PSDATE No No
ASOF_DT PSDATE No No
POST_DT PSDATE No No
DUE_DT PSDATE No No
CR_ANALYST CHAR(8) No No
SALES_PERSON CHAR(8) No No
COLLECTOR CHAR(8) No No
DISPUTE_STATUS CHAR(3) No No
DISPUTE_DT PSDATE No No
DISPUTE_AMOUNT DECIMAL(26,3) No No
PO_REF CHAR(30) No No
PO_LINE SMALLINT No No
DOCUMENT CHAR(30) No No
DOCUMENT_LINE INT No No
POSTED_FLAG CHAR(1) No No
PYMNT_TERMS_CD CHAR(5) No No
DISC_AMT DECIMAL(26,3) No No
DISC_AMT1 DECIMAL(26,3) No No
DISC_DT PSDATE No No
DISC_DT1 PSDATE No No
DISC_DAYS SMALLINT No No
DUE_DAYS SMALLINT No No
ALLOW_DISC CHAR(1) No No
DST_ID_AR CHAR(10) No No
DUN_DT PSDATE No No
ST_DT PSDATE No No
FC_DT PSDATE No No
FC_AMT DECIMAL(26,3) No No
OC_ADMIN_DT PSDATE No No
OC_ADMIN_AMT DECIMAL(26,3) No No
OC_PNLTY_DT PSDATE No No
OC_PNLTY_AMT DECIMAL(26,3) No No
OVERDUE_CHG_LINE CHAR(1) No No
AR_ERROR_CD CHAR(5) No No
ENTRY_USE_ID CHAR(5) No No
DST_BAL_ITEM CHAR(1) No No
COLLECTION_STATUS CHAR(3) No No
COLLECTION_DT PSDATE No No
BILL_OF_LADING CHAR(30) No No
SUBCUST_QUAL1 CHAR(15) No No
SUBCUST_QUAL2 CHAR(15) No No
ENTRY_CURRENCY CHAR(3) No No
RT_TYPE CHAR(5) No No
RATE_MULT DECIMAL(15,8) No No
RATE_DIV DECIMAL(15,8) No No
PAYMENT_AMT DECIMAL(26,3) No No
PAYMENT_CURRENCY CHAR(3) No No
ENTRY_AMT_BASE DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
REAL_GAIN_LOSS DECIMAL(26,3) No No
DST_ID_REAL CHAR(10) No No
ITEM_ACCTG_DT PSDATE No No
VAT_ENTITY CHAR(20) No No
VAT_CALC_GROSS_NET CHAR(1) No No
VAT_EXCPTN_TYPE CHAR(1) No No
VAT_EXCPTN_CERTIF CHAR(20) No No
VAT_DCLRTN_POINT CHAR(1) No No
VAT_RECALC_FLG CHAR(1) No No
VAT_BASIS_AMT DECIMAL(26,3) No No
VAT_BASIS_AMT_BASE DECIMAL(26,3) No No
VAT_AMT DECIMAL(26,3) No No
VAT_AMT_BASE DECIMAL(26,3) No No
COUNTRY_VAT_BILLFR CHAR(3) No No
COUNTRY_VAT_BILLTO CHAR(3) No No
COUNTRY_SHIP_TO CHAR(3) No No
COUNTRY_SHIP_FROM CHAR(3) No No
VAT_DISTRIB_FLG CHAR(1) No No
VAT_RGSTRN_BUYER CHAR(12) No No
VAT_DST_ACCT_TYPE CHAR(4) No No
VAT_ROUND_RULE CHAR(1) No No
ORDER_NO CHAR(10) No No
CONTRACT_NUM CHAR(25) No No
BUSINESS_UNIT_BI CHAR(5) No No
BUSINESS_UNIT_OM CHAR(5) No No
ADDRESS_SEQ_NUM INT No No
LETTER_CD CHAR(3) No No
CONSOL_BUS_UNIT CHAR(5) No No
CONSOL_INVOICE CHAR(22) No No
PAYMENT_METHOD CHAR(3) No No
DRAFT_BU CHAR(5) No No
DRAFT_ID CHAR(15) No No
DRAFT_APPROVAL CHAR(1) No No
DRAFT_DOC CHAR(1) No No
DRAFT_CURRENCY CHAR(3) No No
DRAFT_FORMAT CHAR(1) No No
DRAFT_AMT DECIMAL(26,3) No No
BANK_SETID CHAR(5) No No
BANK_CD CHAR(5) No No
BANK_ACCT_KEY CHAR(4) No No
DD_BU CHAR(5) No No
DD_ID CHAR(15) No No
DD_STATUS CHAR(1) No No
DD_PROFILE_ID CHAR(5) No No
DD_CURRENCY CHAR(3) No No
DD_AMT DECIMAL(26,3) No No
DD_AMT_BASE DECIMAL(26,3) No No
DRAFT_TYPE CHAR(10) No No
DRAFT_AMT_BASE DECIMAL(26,3) No No
DOC_TYPE CHAR(8) No No
DOC_SEQ_NBR CHAR(12) No No
DOC_SEQ_DATE PSDATE No No
DOC_SEQ_STATUS CHAR(1) No No
PROCESS_INSTANCE DECIMAL(10) No No
USER_AMT1 DECIMAL(26,3) No No
USER_AMT2 DECIMAL(26,3) No No
USER_AMT3 DECIMAL(26,3) No No
USER_AMT4 DECIMAL(26,3) No No
USER_AMT5 DECIMAL(26,3) No No
USER_AMT6 DECIMAL(26,3) No No
USER_AMT7 DECIMAL(26,3) No No
USER_AMT8 DECIMAL(26,3) No No
USER_DT1 PSDATE No No
USER_DT2 PSDATE No No
USER_DT3 PSDATE No No
USER_DT4 PSDATE No No
USER1 CHAR(1) No No
USER2 CHAR(1) No No
USER3 CHAR(1) No No
USER4 CHAR(1) No No
USER5 CHAR(1) No No
USER6 CHAR(1) No No
USER7 CHAR(1) No No
USER8 CHAR(1) No No
USER9 CHAR(1) No No
USER10 CHAR(1) No No
DOUBTFUL CHAR(1) No No
DRAFT_BUSN_EVENT CHAR(2) No No
DRAFT_SUB_EVENT CHAR(2) No No
SALES_PERSON2 CHAR(8) No No
REGION_CD CHAR(10) No No
REVALUE_FLAG CHAR(1) No No
PACKSLIP_NO CHAR(22) No No
SBI_NUM CHAR(40) No No
PC_DISTRIB_STATUS CHAR(1) No No
VAT_ADVPAY_FLG CHAR(1) No No
LC_ID CHAR(12) No No
AR_SEQ_NUM INT No No
DRAFT_POST_ACTION CHAR(1) No No
VAT_TRANS_AMT DECIMAL(26,3) No No
RECEIVABLE_TYPE CHAR(3) No No
ENTITY_CODE CHAR(9) No No
CONTROL_AMT DECIMAL(26,3) No No
CONTROL_AMT_BASE DECIMAL(26,3) No No
ANCHOR_BU CHAR(5) No No
ITM_PAY_AMT_BASE DECIMAL(26,3) No No
PPRC_PROMO_CD CHAR(20) No No
CLAIM_NO CHAR(30) No No
CONTROL_CURRENCY CHAR(3) No No
CONTROL_CURR_BASE CHAR(3) No No
CONTROL_RATE_MULT DECIMAL(15,8) No No
CONTROL_RATE_DIV DECIMAL(15,8) No No
CONTROL_RT_TYPE CHAR(5) No No
AR_SPECIALIST CHAR(8) No No
BROKER_ID CHAR(15) No No
CARRIER_ID CHAR(10) No No
CLAIM_DT PSDATE No No
CLASS_OF_TRADE CHAR(20) No No
DEDUCTION_STATUS CHAR(5) No No
DEDUCTION_DT PSDATE No No
DIVISION CHAR(20) No No
DT_INVOICED PSDATE No No
INV_PROD_FAM_CD CHAR(10) No No
INVOICE CHAR(22) No No
INVOICE_BU CHAR(5) No No
MAJOR_CLASS CHAR(10) No No
MEMO_STATUS_CD CHAR(10) No No
MERCH_TYPE CHAR(10) No No
PROOF_OF_DELIVERY CHAR(30) No No
SHIP_FROM_BU CHAR(5) No No
SHIP_TO_ADDR_NUM INT No No
SHIP_TO_CUST_ID CHAR(15) No No
SOLD_TO_ADDR_NUM INT No No
SOLD_TO_CUST_ID CHAR(15) No No
SUB_GROUP_ID INT No No
VAT_TREATMENT_GRP CHAR(4) No No
PHYSICAL_NATURE CHAR(1) No No
COUNTRY_LOC_BUYER CHAR(3) No No
STATE_LOC_BUYER CHAR(6) No No
COUNTRY_LOC_SELLER CHAR(3) No No
STATE_LOC_SELLER CHAR(6) No No
VAT_SVC_SUPPLY_FLG CHAR(1) No No
VAT_SERVICE_TYPE CHAR(1) No No
COUNTRY_VAT_PERFRM CHAR(3) No No
STATE_VAT_PERFRM CHAR(6) No No
COUNTRY_VAT_SUPPLY CHAR(3) No No
STATE_VAT_SUPPLY CHAR(6) No No
STATE_SHIP_FROM CHAR(6) No No
STATE_SHIP_TO CHAR(6) No No
VAT_RPT_CNTRY_SRC CHAR(1) No No
STATE_VAT_DEFAULT CHAR(6) No No
DISC_TAKEN DECIMAL(26,3) No No
GL_LVL CHAR(1) No No
ITEM_LINE_ORIG INT No No
TOT_TAX_AMT DECIMAL(26,3) No No
TOT_TAX_AMT_BSE DECIMAL(26,3) No No
TOT_EXD_AMT DECIMAL(26,3) No No
TOT_EXD_AMT_BSE DECIMAL(26,3) No No
TOT_STX_AMT DECIMAL(26,3) No No
TOT_STX_AMT_BSE DECIMAL(26,3) No No
AG_REF_NBR DECIMAL(16) No No
AR_IU_REQ CHAR(1) No No
CLAIM_SETID CHAR(5) No No
Index
Name Type Unique Member
XPKPENDING_ITEM PK Yes
PS_PENDING_ITEM AK1 Yes
PSAPENDING_ITEM IE1 No
PSBPENDING_ITEM IE2 No
PSCPENDING_ITEM IE3 No
PSDPENDING_ITEM IE4 No
Member(s) of "XPKPENDING_ITEM" Index
GROUP_BU
GROUP_ID
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
GROUP_SEQ_NUM
Member(s) of "PS_PENDING_ITEM" Index
GROUP_BU
GROUP_ID
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
GROUP_SEQ_NUM
Member(s) of "PSAPENDING_ITEM" Index
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
POSTED_FLAG
Member(s) of "PSBPENDING_ITEM" Index
POSTED_FLAG
DST_BAL_ITEM
Member(s) of "PSCPENDING_ITEM" Index
PROCESS_INSTANCE
Member(s) of "PSDPENDING_ITEM" Index
BUSINESS_UNIT
POSTED_FLAG
DISPUTE_STATUS
DUE_DT

Published April 30, 2007