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 |