PeopleSoft 9.0
Cash Management

Table Name PAYMENT_ITEM

Table Description
PAYMENT_ITEM
Columns
Name Datatype Is PK Is FK
DEPOSIT_BU CHAR(5) Yes No
DEPOSIT_ID CHAR(15) Yes No
PAYMENT_SEQ_NUM INT Yes No
BUSINESS_UNIT CHAR(5) Yes No
CUST_ID CHAR(15) Yes No
ITEM CHAR(30) Yes No
ITEM_LINE INT Yes No
AR_SEQ_NUM INT Yes No
ITEM_SELECTED CHAR(1) No No
PAY_AMT DECIMAL(26,3) No No
BAL_AMT DECIMAL(26,3) No No
ORIG_BAL_AMT DECIMAL(26,3) No No
DISC_AMT DECIMAL(26,3) No No
DISC_ORIG_AMT DECIMAL(26,3) No No
DISC_TAKEN DECIMAL(26,3) No No
DISC_STATUS CHAR(1) No No
WS_SEQ INT No No
DISC_ACTION 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
DUE_DT PSDATE No No
ENTRY_USE_ID CHAR(5) No No
DOCUMENT CHAR(30) No No
DISC_AMT1 DECIMAL(26,3) No No
DISC_DT PSDATE No No
DISC_DT1 PSDATE No No
ACCOUNTING_DT PSDATE No No
DST_ID_AR CHAR(10) No No
DISC_DAYS SMALLINT No No
WO_AMT DECIMAL(26,3) No No
ALLOW_DISC CHAR(1) No No
DISC_AVAIL DECIMAL(26,3) No No
SUBCUST_QUAL1 CHAR(15) No No
SUBCUST_QUAL2 CHAR(15) No No
PO_REF CHAR(30) No No
PO_LINE SMALLINT No No
BILL_OF_LADING CHAR(30) No No
PYMNT_TERMS_CD CHAR(5) No No
ASOF_DT PSDATE No No
ITEM_ENTRY_TYPE CHAR(5) No No
ITEM_ENTRY_REASON CHAR(5) No No
WO_ENTRY_TYPE CHAR(5) No No
WO_ENTRY_REASON CHAR(5) No No
WO_ENTRY_USE_ID CHAR(5) No No
ITEM_ACCTG_DT PSDATE No No
BAL_CURRENCY CHAR(3) No No
BAL_AMT_BASE DECIMAL(26,3) No No
RATE_MULT DECIMAL(15,8) No No
RATE_DIV DECIMAL(15,8) No No
PAY_AMT_ITEM DECIMAL(26,3) No No
RT_TYPE_NEW CHAR(5) No No
RATE_MULT_NEW DECIMAL(15,8) No No
RATE_DIV_NEW DECIMAL(15,8) No No
CURRENCY_CD CHAR(3) No No
PAY_AMT_BASE DECIMAL(26,3) No No
REAL_GAIN_LOSS DECIMAL(26,3) No No
DISC_REAL_GAINLOSS DECIMAL(26,3) No No
DST_ID_REAL CHAR(10) No No
WO_AMT_BASE DECIMAL(26,3) No No
DISC_BASE DECIMAL(26,3) No No
WO_AMT_PAY DECIMAL(26,3) No No
DISC_PAY DECIMAL(26,3) No No
ORDER_NO CHAR(10) No No
CONTRACT_NUM CHAR(25) No No
PAYMENT_CURRENCY CHAR(3) 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
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_TREATMENT_GRP CHAR(4) No No
VAT_RGSTRN_BUYER CHAR(12) No No
VAT_ROUND_RULE CHAR(1) No No
NEW_WS_ITEM CHAR(1) No No
DD_BU CHAR(5) No No
DD_ID CHAR(15) No No
DD_CURRENCY CHAR(3) No No
DD_PROFILE_ID CHAR(5) No No
DD_STATUS CHAR(1) No No
DRAFT_TYPE CHAR(10) No No
CR_ANALYST CHAR(8) No No
COLLECTOR CHAR(8) No No
SALES_PERSON CHAR(8) No No
SALES_PERSON2 CHAR(8) No No
REGION_CD CHAR(10) No No
DOUBTFUL CHAR(1) No No
REVALUE_FLAG CHAR(1) No No
DRAFT_BUSN_EVENT CHAR(2) No No
DRAFT_SUB_EVENT CHAR(2) No No
VAT_ADVPAY_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
VAT_TRANS_AMT DECIMAL(26,3) No No
PACKSLIP_NO CHAR(22) No No
SBI_NUM CHAR(40) No No
LC_ID CHAR(12) No No
ITM_PAY_AMT_BASE DECIMAL(26,3) No No
MRL_STATUS CHAR(1) No No
MRL_TAX_AMT 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
DISC_PAY_AMT_BASE DECIMAL(26,3) 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
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
DISPUTE_STATUS CHAR(3) No No
COLLECTION_STATUS CHAR(3) 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
GL_LVL CHAR(1) No No
CONVERS_EXISTS CHAR(1) No No
ADDRESS_SEQ_NUM INT No No
AG_REF_NBR DECIMAL(16) No No
Index
Name Type Unique Member
XPKPAYMENT_ITEM PK Yes
PS_PAYMENT_ITEM AK1 Yes
PSAPAYMENT_ITEM IE1 No
Member(s) of "XPKPAYMENT_ITEM" Index
DEPOSIT_BU
DEPOSIT_ID
PAYMENT_SEQ_NUM
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
AR_SEQ_NUM
Member(s) of "PS_PAYMENT_ITEM" Index
DEPOSIT_BU
DEPOSIT_ID
PAYMENT_SEQ_NUM
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
AR_SEQ_NUM
Member(s) of "PSAPAYMENT_ITEM" Index
CUST_ID
BUSINESS_UNIT
ITEM
ITEM_LINE
ITEM_SELECTED

Published April 30, 2007