PeopleSoft 9.0
Cash Management

Table Name DD_ITEM

Table Description
DD_ITEM
Columns
Name Datatype Is PK Is FK
DD_BU CHAR(5) Yes No
DD_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
PROCESS_INSTANCE DECIMAL(10) Yes No
ASOF_DT PSDATE No No
ITEM_SELECTED CHAR(1) No No
DD_STATUS CHAR(1) No No
ENTRY_TYPE CHAR(5) No No
ENTRY_REASON CHAR(5) No No
ENTRY_EVENT CHAR(10) No No
BAL_AMT DECIMAL(26,3) No No
BAL_AMT_BASE DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
ENTRY_CURRENCY CHAR(3) No No
DD_CURRENCY CHAR(3) No No
RATE_MULT DECIMAL(15,8) No No
RATE_DIV DECIMAL(15,8) No No
PO_REF CHAR(30) No No
PO_LINE SMALLINT No No
DOCUMENT CHAR(30) No No
DUE_DT PSDATE No No
DELETE_ME CHAR(1) No No
SUBCUST_QUAL1 CHAR(15) No No
SUBCUST_QUAL2 CHAR(15) No No
ORDER_NO CHAR(10) No No
CONTRACT_NUM CHAR(25) No No
BILL_OF_LADING CHAR(30) No No
ACCOUNTING_DT PSDATE No No
PYMNT_TERMS_CD CHAR(5) No No
VAT_TXN_TYPE_CD CHAR(4) 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
DST_ID_AR CHAR(10) No No
RT_TYPE CHAR(5) No No
ITM_MULTIPLIER SMALLINT No No
MRL_STATUS CHAR(1) No No
MRL_TAX_AMT DECIMAL(26,3) No No
Index
Name Type Unique Member
XPKDD_ITEM PK Yes
PS_DD_ITEM AK1 Yes
PSADD_ITEM IE1 No
Member(s) of "XPKDD_ITEM" Index
DD_BU
DD_ID
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
PROCESS_INSTANCE
Member(s) of "PS_DD_ITEM" Index
DD_BU
DD_ID
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
PROCESS_INSTANCE
Member(s) of "PSADD_ITEM" Index
BUSINESS_UNIT
CUST_ID
ITEM
ITEM_LINE
ITEM_SELECTED

Published April 30, 2007