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 |
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 |