PeopleSoft 9.0
Cash Management

Table Name TRN_ITEM

Table Description
TRN_ITEM
Columns
Name Datatype Is PK Is FK
TRN_BU CHAR(5) Yes No
TRN_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
WS_SEQ INT Yes No
ITEM_SELECTED CHAR(1) No No
ENTRY_USE_ID CHAR(5) 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
REQUIRE_REASON CHAR(1) No No
BAL_AMT DECIMAL(26,3) No No
ACCOUNTING_DT PSDATE No No
ASOF_DT PSDATE No No
DUE_DT PSDATE No No
PO_REF CHAR(30) No No
DOCUMENT CHAR(30) No No
DOCUMENT_LINE INT No No
DST_ID_AR CHAR(10) No No
DST_ID_VAT CHAR(10) No No
BILL_OF_LADING CHAR(30) No No
SUBCUST_QUAL1 CHAR(15) No No
SUBCUST_QUAL2 CHAR(15) 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
CURRENCY_CD CHAR(3) No No
PYMNT_TERMS_CD CHAR(5) No No
ITEM_ACCTG_DT PSDATE No No
ITEM_ENTRY_TYPE CHAR(5) No No
ITEM_ENTRY_REASON CHAR(5) No No
AMT_REM DECIMAL(26,3) No No
BUSINESS_UNIT_GL CHAR(5) No No
DISC_DT PSDATE No No
MATCH_SEQ CHAR(1) No No
REAL_GAIN_LOSS DECIMAL(26,3) No No
RATE_MULT_ORIG DECIMAL(15,8) No No
RATE_DIV_ORIG DECIMAL(15,8) No No
CURRENCY_CD_ORIG CHAR(3) No No
BAL_AMT_ORIG DECIMAL(15,2) No No
DST_ID_REAL CHAR(10) No No
SETID CHAR(5) No No
AMT_SEL DECIMAL(26,3) No No
ITEM_AMT DECIMAL(26,3) No No
ITEM_AMT_BASE DECIMAL(26,3) No No
ITEM_MTCH CHAR(33) No No
ITEM_LINE_MTCH INT No No
ORDER_NO CHAR(10) No No
CONTRACT_NUM CHAR(25) No No
ITEM_ENTRY_USE CHAR(5) No No
TO_BU CHAR(5) No No
TO_CUST_ID CHAR(15) No No
TO_SUBCUST_QUAL1 CHAR(15) No No
TO_SUBCUST_QUAL2 CHAR(15) No No
CR_ANALYST CHAR(8) No No
SALES_PERSON CHAR(8) No No
COLLECTOR CHAR(8) No No
TO_COLLECTOR CHAR(8) No No
TO_SALES_PERSON CHAR(8) No No
TO_CR_ANALYST CHAR(8) No No
TO_DST_ID_AR CHAR(10) No No
TO_ENTRY_TYPE CHAR(5) No No
TO_ENTRY_REASON CHAR(5) No No
TO_ENTRY_EVENT CHAR(10) No No
TO_GL_BU CHAR(5) No No
TO_BROKER_ID CHAR(15) No No
TO_INV_PROD_FAM_CD CHAR(10) No No
TO_SHIP_TO_CUST_ID CHAR(15) No No
TO_SOLD_TO_CUST_ID CHAR(15) No No
TO_AR_SPECIALIST CHAR(8) No No
FROM_GL_BU CHAR(5) No No
INTERCO_XREF CHAR(1) No No
TO_SETID_ENTRY CHAR(5) No No
FROM_SETID_ENTRY CHAR(5) No No
DOUBTFUL CHAR(1) No No
SALES_PERSON2 CHAR(8) No No
REGION_CD CHAR(10) No No
REVALUE_FLAG CHAR(1) No No
LC_ID CHAR(12) No No
AG_REF_NBR DECIMAL(16) No No
VAT_DCLRTN_POINT CHAR(1) No No
CONTROL_AMT DECIMAL(26,3) No No
CONTROL_AMT_BASE DECIMAL(26,3) No No
DST_ID_TRAN_CTL CHAR(10) 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
ADDRESS_SEQ_NUM INT No No
CLAIM_NO CHAR(30) 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
DISPUTE_STATUS CHAR(3) No No
COLLECTION_STATUS CHAR(3) 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
Index
Name Type Unique Member
XPKTRN_ITEM PK Yes
PS_TRN_ITEM AK1 Yes
Member(s) of "XPKTRN_ITEM" Index
TRN_BU
TRN_ID
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
WS_SEQ
Member(s) of "PS_TRN_ITEM" Index
TRN_BU
TRN_ID
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
WS_SEQ

Published April 30, 2007