PeopleSoft 9
Account Payables

Table Name BUS_UNIT_TBL_PM

Table Description
BUS_UNIT_TBL_PM
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes No
BUSINESS_UNIT_GL VARCHAR(5) No No
BUSINESS_UNIT_AM VARCHAR(5) No No
BUSINESS_UNIT_AP VARCHAR(5) No No
BU_PSGL_SW VARCHAR(1) No No
PRCS_OPTION_ID VARCHAR(5) No No
REQ_NUM_OPTION VARCHAR(1) No No
REQ_ID_LAST_USED decimal(10) No No
PO_NUM_OPTION VARCHAR(1) No No
PO_ID_LAST_USED decimal(10) No No
RECV_NUM_OPTION VARCHAR(1) No No
RECV_ID_LAST_USED decimal(10) No No
ADJ_RECV_DATE_NBR SMALLINT No No
CURRENCY_CD VARCHAR(3) No No
RT_TYPE VARCHAR(5) No No
PO_ITM_VNDR_OPT VARCHAR(1) No No
RFQ_NUM_OPTION VARCHAR(1) No No
RFQ_ID_LAST_USED decimal(10) No No
POST_OPTION VARCHAR(1) No No
POST_DT_SW VARCHAR(1) No No
POST_THRU_DT PSDATE No No
CLOSE_DELAY_DAYS int No No
CANCEL_DELAY_DAYS int No No
LOCATION VARCHAR(10) No No
BILL_LOCATION VARCHAR(10) No No
DB_NUMBER VARCHAR(9) No No
CHNG_TMPLT_ID VARCHAR(10) No No
FINANCIAL_ASSET_SW VARCHAR(1) No No
BUSPROCNAME_PO VARCHAR(30) No No
PO_AMT_APPR_NEEDED VARCHAR(1) No No
APPR_RULE_PO_AMT VARCHAR(30) No No
PO_CF_APPR_NEEDED VARCHAR(1) No No
APPR_RULE_PO_CF VARCHAR(30) No No
TAX_EXEMPT VARCHAR(1) No No
TAX_EXEMPT_ID VARCHAR(13) No No
ACCRUE_USE_TAX VARCHAR(1) No No
ORIGIN_AP VARCHAR(3) No No
BUSPROCNAME_REQ VARCHAR(30) No No
REQ_AMT_APPR_REQD VARCHAR(1) No No
APPR_RULE_REQ_AMT VARCHAR(30) No No
REQ_CF_APPR_REQD VARCHAR(1) No No
APPR_RULE_REQ_CF VARCHAR(30) No No
ALLOW_MC_PO VARCHAR(1) No No
ALLOW_MC_REQ VARCHAR(1) No No
PCT_UNIT_PRC_TOL decimal(5,2) No No
RTV_ID_LAST_USED decimal(10) No No
RTV_NUM_OPTION VARCHAR(1) No No
MATCH_OPT VARCHAR(1) No No
MATCH_CNTRL_ID VARCHAR(10) No No
ITEM_BU_ATTR VARCHAR(1) No No
STD_COMMENT_TYPE VARCHAR(3) No No
STD_COMMENT_ID VARCHAR(4) No No
PO_IMAGE_PATH VARCHAR(100) No No
PO_IMAGE_SIG_PATH VARCHAR(100) No No
PRINT_IMAGE VARCHAR(1) No No
PRINT_IMAGE_SIG VARCHAR(1) No No
RECEIPT_ACCR_FLAG VARCHAR(1) No No
SEPARATE_INSPECT VARCHAR(1) No No
RTV_ADJ_FEES VARCHAR(1) No No
RTV_ADJ_SOURCE VARCHAR(1) No No
TMP_PO_LAST_USED decimal(10) No No
RTV_REOPEN_PO VARCHAR(1) No No
PCT_UNIT_PRC_TOL_L decimal(5,2) No No
RECVLOAD_CASCADE VARCHAR(1) No No
RECEIPT_ALLOC_TYPE VARCHAR(1) No No
NONPO_ACCR_FLAG VARCHAR(1) No No
VAT_APORT_CNTRL VARCHAR(1) No No
DELETE_PO_ALLOWED VARCHAR(1) No No
DELETE_REQ_ALLOWED VARCHAR(1) No No
PO_ENTRY_EVENT VARCHAR(10) No No
REQ_ENTRY_EVENT VARCHAR(10) No No
CC_ENTRY_EVENT VARCHAR(10) No No
REQ_CHNG_ORD_OPTN VARCHAR(1) No No
CHNG_TMPLT_ID_REQ VARCHAR(10) No No
PO_POA_AUTOAPPROVE VARCHAR(1) No No
AUTOAPPROVE_CHNG VARCHAR(1) No No
BUSINESS_UNIT_SS VARCHAR(5) No No
ALLOW_CURR_UR VARCHAR(1) No No
LIQUIDATE_BY_QTY VARCHAR(1) No No
LIQUIDATE_METHOD VARCHAR(1) No No
TAX_VENDOR VARCHAR(1) No No
TAX_COMPANY VARCHAR(5) No No
TAX_DIVISION VARCHAR(5) No No
TAX_VNDR_FRGHT_FLG VARCHAR(1) No No
CALC_ADJ_ON_REQ VARCHAR(1) No No
RFQ_REQUIRED_LIMIT decimal(26,3) No No
RFQ_REQUIRED_RULE VARCHAR(10) No No
PO_PRICE_EDIT VARCHAR(1) No No
CHNG_MAP_TMPLT_ID VARCHAR(10) No No
TAX_DEPARTMENT VARCHAR(5) No No
Index
Name Type Unique Member
PS_BUS_UNIT_TBL_PM PK Yes
Member(s) of "PS_BUS_UNIT_TBL_PM" Index
BUSINESS_UNIT

Published June 06, 2007