PeopleSoft 9
Account Payables

Table Name PO_HDR

Table Description
PO_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
PO_ID VARCHAR(10) Yes No
CHNG_ORD_BATCH SMALLINT No No
PO_TYPE VARCHAR(4) No No
PO_STATUS VARCHAR(2) No No
HOLD_STATUS VARCHAR(1) No No
RECV_STATUS VARCHAR(1) No No
DISP_ACTION VARCHAR(1) No No
DISP_METHOD VARCHAR(3) No No
CHANGE_STATUS VARCHAR(1) No No
PO_DT PSDATE No No
PO_REF VARCHAR(30) No No
VENDOR_SETID VARCHAR(5) No No
VENDOR_ID VARCHAR(10) No Yes
VNDR_LOC VARCHAR(10) No Yes
PRICE_SETID VARCHAR(5) No No
PRICE_VENDOR VARCHAR(10) No No
PRICE_LOC VARCHAR(10) No No
PYMNT_TERMS_CD VARCHAR(5) No No
BUYER_ID VARCHAR(30) No No
ORIGIN VARCHAR(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 VARCHAR(10) No No
TAX_EXEMPT VARCHAR(1) No No
TAX_EXEMPT_ID VARCHAR(13) No No
CURRENCY_CD VARCHAR(3) No No
RT_TYPE VARCHAR(5) No No
MATCH_ACTION VARCHAR(1) No No
MATCH_CNTRL_ID VARCHAR(10) No No
MATCH_STATUS_PO VARCHAR(1) No No
MATCH_PROCESS_FLG VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
APPL_JRNL_ID_ENC VARCHAR(10) No No
POST_DOC VARCHAR(1) No No
DST_CNTRL_ID VARCHAR(10) No No
OPRID_ENTERED_BY VARCHAR(30) No No
ENTERED_DT PSDATE No No
OPRID_APPROVED_BY VARCHAR(30) No No
APPROVAL_DT PSDATE No No
OPRID_MODIFIED_BY VARCHAR(30) No No
LAST_DTTM_UPDATE PSDATETIME No No
ACCOUNTING_DT PSDATE No No
BUSINESS_UNIT_GL VARCHAR(5) No No
IN_PROCESS_FLG VARCHAR(1) No No
ACTIVITY_DATE PSDATE No No
PO_POST_STATUS VARCHAR(1) No No
NEXT_MOD_SEQ_NBR SMALLINT No No
ERS_ACTION VARCHAR(1) No No
ACCRUE_USE_TAX VARCHAR(1) No No
CURRENCY_CD_BASE VARCHAR(3) No No
RATE_DATE PSDATE No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
VAT_ENTITY VARCHAR(20) No No
BUDGET_HDR_STATUS VARCHAR(1) No No
KK_AMOUNT_TYPE VARCHAR(1) No No
KK_TRAN_OVER_FLAG VARCHAR(1) No No
KK_TRAN_OVER_OPRID VARCHAR(30) No No
KK_TRAN_OVER_DTTM PSDATETIME No No
LC_ID VARCHAR(12) No No
BUDGET_HDR_STS_NP VARCHAR(1) No No
PREPAID_PO_FLG VARCHAR(1) No No
PREPAID_AMT decimal(26,3) No No
PREPAID_AUTH_STAT VARCHAR(1) No No
PREPAID_STATUS_PO VARCHAR(1) No No
PAY_TRM_BSE_DT_OPT VARCHAR(1) No No
TERMS_BASIS_DT PSDATE No No
BACKORDER_STATUS VARCHAR(1) No No
DOC_TOL_HDR_STATUS VARCHAR(1) No No
MID_ROLL_STATUS VARCHAR(1) No No
USER_HDR_CHAR1 VARCHAR(1) No No
BUDGET_CHECK VARCHAR(1) No No
POA_STATUS VARCHAR(2) No No
POA_REQS VARCHAR(1) No No
CC_SECURITY_ID DECIMAL(10) No No
CC_USE_FLAG VARCHAR(1) No No
CC_DISP_OPTION VARCHAR(1) No No
CONTACT_NAME VARCHAR(50) No No
CONTACT_PHONE VARCHAR(24) No No
TEXT254_CC2 VARCHAR(254) No No
Index
Name Type Unique Member
PS_PO_HDR PK Yes
PS0PO_HDR IE21 No
PS1PO_HDR IE22 No
PS2PO_HDR IE23 No
PSAPO_HDR IE24 No
PSBPO_HDR IE25 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 June 06, 2007