PeopleSoft 9
Asset Management

Table Name PO_HDR

Table Description
PO_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes No
PO_ID char(10) Yes No
CHNG_ORD_BATCH smallint No No
PO_TYPE char(4) No No
PO_STATUS char(2) No No
HOLD_STATUS char(1) No No
RECV_STATUS char(1) No No
DISP_ACTION char(1) No No
DISP_METHOD char(3) No No
CHANGE_STATUS char(1) No No
PO_DT PSDATE No No
PO_REF char(30) No No
VENDOR_SETID char(5) No No
VENDOR_ID char(10) No No
VNDR_LOC char(10) No No
PRICE_SETID char(5) No No
PRICE_VENDOR char(10) No No
PRICE_LOC char(10) No No
PYMNT_TERMS_CD char(5) No No
BUYER_ID char(30) No No
ORIGIN char(3) No No
CHNG_ORD_SEQ smallint No No
ADDRESS_SEQ_NUM INT No No
CNTCT_SEQ_NUM INT No No
SALES_CNTCT_SEQ_N smallint No No
BILL_LOCATION char(10) No No
TAX_EXEMPT char(1) No No
TAX_EXEMPT_ID char(13) No No
CURRENCY_CD char(3) No No
RT_TYPE char(5) No No
MATCH_ACTION char(1) No No
MATCH_CNTRL_ID char(10) No No
MATCH_STATUS_PO char(1) No No
MATCH_PROCESS_FLG char(1) No No
PROCESS_INSTANCE decimal(10) No No
APPL_JRNL_ID_ENC char(10) No No
POST_DOC char(1) No No
DST_CNTRL_ID char(10) No No
OPRID_ENTERED_BY char(30) No No
ENTERED_DT PSDATE No No
OPRID_APPROVED_BY char(30) No No
APPROVAL_DT PSDATE No No
OPRID_MODIFIED_BY char(30) No No
LAST_DTTM_UPDATE PSDATETIME No No
ACCOUNTING_DT PSDATE No No
BUSINESS_UNIT_GL char(5) No No
IN_PROCESS_FLG char(1) No No
ACTIVITY_DATE PSDATE No No
PO_POST_STATUS char(1) No No
NEXT_MOD_SEQ_NBR smallint No No
ERS_ACTION char(1) No No
ACCRUE_USE_TAX char(1) No No
CURRENCY_CD_BASE char(3) No No
RATE_DATE PSDATE No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
VAT_ENTITY char(20) No No
BUDGET_HDR_STATUS char(1) No No
KK_AMOUNT_TYPE char(1) No No
KK_TRAN_OVER_FLAG char(1) No No
KK_TRAN_OVER_OPRID char(30) No No
KK_TRAN_OVER_DTTM PSDATETIME No No
LC_ID char(12) No No
BUDGET_HDR_STS_NP char(1) No No
PREPAID_PO_FLG char(1) No No
PREPAID_AMT decimal(26,3) No No
PREPAID_AUTH_STAT char(1) No No
PREPAID_STATUS_PO char(1) No No
PAY_TRM_BSE_DT_OPT char(1) No No
TERMS_BASIS_DT PSDATE No No
BACKORDER_STATUS char(1) No No
DOC_TOL_HDR_STATUS char(1) No No
MID_ROLL_STATUS char(1) No No
USER_HDR_CHAR1 char(1) No No
BUDGET_CHECK char(1) No No
POA_STATUS char(2) No No
POA_REQS char(1) No No
CC_SECURITY_ID decimal(10) No No
CC_USE_FLAG char(1) No No
CC_DISP_OPTION char(1) No No
CONTACT_NAME char(50) No No
CONTACT_PHONE char(24) No No
TEXT254_CC2 char(254) No No
Index
Name Type Unique Member
PS_PO_HDR PK Yes
PS0PO_HDR IE1 No
PS1PO_HDR IE2 No
PS2PO_HDR IE3 No
PSAPO_HDR IE4 No
PSBPO_HDR IE5 No
Member(s) of "PS_PO_HDR" Index
BUSINESS_UNIT
PO_ID
Member(s) of "PS0PO_HDR" Index
PO_DT
BUSINESS_UNIT
PO_ID
Member(s) of "PS1PO_HDR" Index
PO_REF
BUSINESS_UNIT
PO_ID
Member(s) of "PS2PO_HDR" Index
VENDOR_ID
BUSINESS_UNIT
PO_ID
Member(s) of "PSAPO_HDR" Index
BUSINESS_UNIT
PO_STATUS
Member(s) of "PSBPO_HDR" Index
PROCESS_INSTANCE

Published December 16, 2006