PeopleSoft 9.0
Cash Management

Table Name ITEM

Table Description
ITEM
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes No
CUST_ID char(15) Yes No
ITEM char(30) Yes No
ITEM_LINE int Yes No
ITEM_STATUS char(1) No No
ENTRY_TYPE char(5) No No
ENTRY_REASON char(5) No No
ENTRY_EVENT char(10) No No
REF_REASON char(5) No No
BAL_AMT decimal(26,3) No No
ACCOUNTING_DT datetime No No
ASOF_DT datetime No No
POST_DT datetime No No
DUE_DT datetime 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 datetime 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
PYMNT_TERMS_CD char(5) No No
DISC_AMT decimal(26,3) No No
DISC_AMT1 decimal(26,3) No No
DISC_DT datetime No No
DISC_DT1 datetime No No
DISC_LEVEL char(1) No No
DISC_DAYS smallint No No
DUE_DAYS smallint No No
ALLOW_DISC char(1) No No
AGING_CATEGORY char(2) No No
DST_ID_AR char(10) No No
HIST_STATUS char(1) No No
DUN_DT datetime No No
DUN_SEQ_NUM smallint No No
ST_DT datetime No No
FC_DT datetime No No
FC_AMT decimal(26,3) No No
OC_ADMIN_DT datetime No No
OC_ADMIN_AMT decimal(26,3) No No
OC_PNLTY_DT datetime No No
OC_PNLTY_AMT decimal(26,3) No No
OVERDUE_CHG_LINE char(1) No No
ITEM_LINE_ORIG int No No
UPDATE_STATUS char(1) No No
COLLECTION_STATUS char(3) No No
COLLECTION_DT datetime No No
ITEM_SEQ_NUM smallint No No
BILL_OF_LADING char(30) No No
SUBCUST_QUAL1 char(15) No No
SUBCUST_QUAL2 char(15) No No
SUBCUST_STATUS char(1) No No
BAL_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
BAL_AMT_BASE decimal(26,3) No No
BAL_AMT_LAST decimal(26,3) No No
CURRENCY_CD char(3) No No
ENTRY_USE_ID char(5) No No
VAT_DCLRTN_POINT char(1) No No
VAT_RECALC_FLG char(1) 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_CALC_GROSS_NET char(1) No No
VAT_ENTITY char(20) No No
VAT_EXCPTN_TYPE char(1) No No
VAT_EXCPTN_CERTIF char(20) No No
VAT_RGSTRN_BUYER char(12) 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
TRAN_FROM_BU char(5) No No
TRAN_FROM_CUSTID char(15) 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_STATUS char(1) 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_CURRENCY char(3) No No
DD_STATUS char(1) No No
DD_PROFILE_ID char(5) No No
DRAFT_TYPE char(10) 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 datetime No No
USER_DT2 datetime No No
USER_DT3 datetime No No
USER_DT4 datetime 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
ORIG_ITEM_AMT decimal(26,3) No No
LAST_ACTIVITY_DT datetime No No
ST_ID_NUM int 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
LC_ID char(12) No No
NETTING_SW char(1) No No
NET_REF_ID char(12) No No
RECEIVABLE_TYPE char(3) No No
ENTITY_CODE char(9) No No
PPRC_PROMO_CD char(20) No No
CLAIM_NO char(30) No No
CLAIM_SETID char(5) No No
AR_SPECIALIST char(8) No No
BROKER_ID char(15) No No
CARRIER_ID char(10) No No
CLAIM_DT datetime No No
CLASS_OF_TRADE char(20) No No
DEDUCTION_STATUS char(5) No No
DEDUCTION_DT datetime No No
DIVISION char(20) No No
DT_INVOICED datetime 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
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
CONVERS_EXISTS char(1) No No
AG_REF_NBR decimal(16) No No
Index
Name Type Unique Member
PS_ITEM PK Yes
PSFITEM AK2 Yes
PS0ITEM IE1 No
PSDITEM IE10 No
PSEITEM IE11 No
PS1ITEM IE2 No
PS2ITEM IE3 No
PS3ITEM IE4 No
PS4ITEM IE5 No
PS5ITEM IE6 No
PSAITEM IE7 No
PSBITEM IE8 No
PSCITEM IE9 No
Member(s) of "PS_ITEM" Index
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
Member(s) of "PSFITEM" Index
PROCESS_INSTANCE
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
Member(s) of "PS0ITEM" Index
ITEM_STATUS
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
Member(s) of "PSDITEM" Index
CUST_ID
ITEM
Member(s) of "PSEITEM" Index
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE_ORIG
OVERDUE_CHG_LINE
Member(s) of "PS1ITEM" Index
CR_ANALYST
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
Member(s) of "PS2ITEM" Index
COLLECTOR
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
Member(s) of "PS3ITEM" Index
PO_REF
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
Member(s) of "PS4ITEM" Index
DOCUMENT
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
Member(s) of "PS5ITEM" Index
BILL_OF_LADING
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
Member(s) of "PSAITEM" Index
DRAFT_ID
DRAFT_BU
Member(s) of "PSBITEM" Index
BAL_CURRENCY
Member(s) of "PSCITEM" Index
ITEM
ITEM_STATUS
CURRENCY_CD

Published April 30, 2007