PeopleSoft 9
Asset Management

Table Name ASSET_ACQ_DET

Table Description
ASSET_ACQ_DET
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
SEQUENCE_NBR_6 int Yes No
SYSTEM_SOURCE char(3) No No
DESCR char(30) No No
CAPITALIZATION_SW char(1) No No
BUSINESS_UNIT_PO char(5) No No
PO_ID char(10) No No
PO_LINE_NBR int No No
PO_DIST_LINE_NUM int No No
SCHED_NBR smallint No No
REFERENCE_ID char(10) No No
BUSINESS_UNIT_AP char(5) No No
VOUCHER_ID char(8) No No
VOUCHER_LINE_NUM int No No
DISTRIB_LINE_NUM int No No
INVOICE_DT PSDATE No No
VENDOR_ID char(10) No Yes
VENDOR_NAME char(30) No No
INVOICE_ID char(30) No No
TXN_CURRENCY_CD char(3) No No
CURRENCY_CD char(3) No Yes
TXN_AMOUNT decimal(26,3) No No
AMOUNT decimal(26,3) No No
QUANTITY decimal(15,4) No No
SALETX_AMT decimal(26,3) No No
SALETX_AMT_BSE decimal(26,3) No No
SALETX_CD char(8) No No
USETAX_AMT decimal(26,3) No No
USETAX_AMT_BSE decimal(26,3) No No
USETAX_CD char(8) No No
FREIGHT_AMT decimal(26,3) No No
FREIGHT_AMT_BSE decimal(26,3) No No
OPERATING_UNIT char(8) No No
PRODUCT char(6) No No
FUND_CODE char(5) No No
CLASS_FLD char(5) No No
PROGRAM_CODE char(5) No No
BUDGET_REF char(8) No No
AFFILIATE char(5) No No
AFFILIATE_INTRA1 char(10) No No
AFFILIATE_INTRA2 char(10) No No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
PROJECT_ID char(15) No No
DEPTID char(10) No No
CATEGORY char(5) No Yes
COST_TYPE char(1) No Yes
BUSINESS_UNIT_PC char(5) No No
MASTER_PROJECT char(15) No No
ACTIVITY_ID char(15) No No
ANALYSIS_TYPE char(3) No No
RESOURCE_TYPE char(5) No No
RESOURCE_CATEGORY char(5) No No
RESOURCE_SUB_CAT char(5) No No
BUSINESS_UNIT_RECV char(5) No No
RECEIVER_ID char(10) No No
RECV_LN_NBR int No No
RECV_DIST_LINE_NUM int No No
RECV_SHIP_SEQ_NBR smallint No No
DISTRIB_SEQ_NUM int No No
INV_ITEM_ID char(18) No No
INCENTIVE_ID char(10) No No
MERCHANDISE_AMT decimal(26,3) No No
MERCH_AMT_BSE decimal(26,3) No No
MISC_AMT decimal(26,3) No No
MISC_AMT_BSE decimal(26,3) No No
VAT_INV_AMT decimal(26,3) No No
VAT_INV_AMT_BSE decimal(26,3) No No
VAT_NRCVR_AMT decimal(26,3) No No
VAT_NRCVR_AMT_BSE decimal(26,3) No No
VAT_RCVRY_AMT decimal(26,3) No No
VAT_RCVRY_AMT_BSE decimal(26,3) No No
ADJUSTMENT_DT PSDATE No No
VAT_TRANS_TYPE char(3) No No
RT_TYPE char(5) No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
RT_EFFDT PSDATE No No
Index
Name Type Unique Member
PS_ASSET_ACQ_DET PK Yes
PSAASSET_ACQ_DET IE1 No
PSBASSET_ACQ_DET IE2 No
PSCASSET_ACQ_DET IE3 No
PSDASSET_ACQ_DET IE4 No
Member(s) of "PS_ASSET_ACQ_DET" Index
BUSINESS_UNIT
ASSET_ID
SEQUENCE_NBR_6
Member(s) of "PSAASSET_ACQ_DET" Index
BUSINESS_UNIT
ASSET_ID
Member(s) of "PSBASSET_ACQ_DET" Index
BUSINESS_UNIT_PO
PO_ID
PO_LINE_NBR
PO_DIST_LINE_NUM
SCHED_NBR
Member(s) of "PSCASSET_ACQ_DET" Index
BUSINESS_UNIT_AP
VOUCHER_ID
VOUCHER_LINE_NUM
DISTRIB_LINE_NUM
Member(s) of "PSDASSET_ACQ_DET" Index
BUSINESS_UNIT_RECV
RECEIVER_ID
RECV_LN_NBR
RECV_DIST_LINE_NUM
RECV_SHIP_SEQ_NBR
DISTRIB_SEQ_NUM

Published December 16, 2006