PeopleSoft 9
Account Payables

Table Name BUS_UNIT_TBL_IN

Table Description
BUS_UNIT_TBL_IN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes No
BASE_CURRENCY VARCHAR(3) No No
BUSINESS_UNIT_GL VARCHAR(5) No No
DOWNTIME_FLAG VARCHAR(1) No No
IBU_GROUP VARCHAR(10) No No
BU_STATUS VARCHAR(1) No No
WRKFL_SHIPPING VARCHAR(1) No No
LOCATION VARCHAR(10) No No
INVENTORY_TAG_ID decimal(15) No No
STAGING_ID decimal(15) No No
PICK_BATCH_ID decimal(10) No No
SHIPPING_ID decimal(10) No No
COUNTING_EVENT_ID decimal(15) No No
REPLENISH_ID decimal(10) No No
ACCTG_LINE_NO decimal(15) No No
CART_COUNT_ID decimal(10) No No
RUN_CNTL_SEQ_NBR decimal(10) No No
BUSIN_UNIT_TYPE VARCHAR(4) No No
BUSINESS_UNIT_BI VARCHAR(5) No No
BILL_TYPE_ID VARCHAR(3) No No
BILL_SOURCE_ID VARCHAR(10) No No
INCL_QUAR_AVAIL VARCHAR(1) No No
LOT_AUTO_ADD_FLG VARCHAR(1) No No
LOT_ALLOC_FLG VARCHAR(1) No No
LOT_ALLOC_WL_FLG VARCHAR(1) No No
COMBO_EDIT_FLG VARCHAR(1) No No
COMBO_VALID_FLG VARCHAR(1) No No
SPEEDTYPE_LVL VARCHAR(1) No No
FREIGHT_PROD_ID VARCHAR(18) No No
MISC_CHRG_PROD_ID VARCHAR(18) No No
TRANSIT_COST_TYP VARCHAR(1) No No
DST_ID_REV VARCHAR(10) No No
DST_ID_DIS VARCHAR(10) No No
DST_ID_SUR VARCHAR(10) No No
APPL_JRNL_ID VARCHAR(10) No No
ALLOW_NEG_INV_FLG VARCHAR(1) No No
DISPLAY_MESSAGE VARCHAR(1) No No
PICK_EXT_FILE_CNT SMALLINT No No
CART_REPLEN_OPT VARCHAR(2) No No
CONS_NON_STOCK VARCHAR(1) No No
BCKORDR_CNCL_FLAG VARCHAR(1) No No
PTWY_PLAN_ID decimal(10) No No
TAXPAYER_ID VARCHAR(14) No No
MSR_MONTHS SMALLINT No No
REASON_CD VARCHAR(10) No No
RETURN_TO_IBU VARCHAR(5) No No
DISTRIB_TYPE VARCHAR(10) No No
ACCOUNT VARCHAR(10) No No
ALTACCT VARCHAR(10) No No
DEPTID VARCHAR(10) No No
OPERATING_UNIT VARCHAR(8) No No
PRODUCT VARCHAR(6) No No
FUND_CODE VARCHAR(5) No No
CLASS_FLD VARCHAR(5) No No
PROGRAM_CODE VARCHAR(5) No No
BUDGET_REF VARCHAR(8) No No
AFFILIATE VARCHAR(5) No No
AFFILIATE_INTRA1 VARCHAR(10) No No
AFFILIATE_INTRA2 VARCHAR(10) No No
CHARTFIELD1 VARCHAR(10) No No
CHARTFIELD2 VARCHAR(10) No No
CHARTFIELD3 VARCHAR(10) No No
BUSINESS_UNIT_PC VARCHAR(5) No No
PROJECT_ID VARCHAR(15) No No
ACTIVITY_ID VARCHAR(15) No No
RESOURCE_TYPE VARCHAR(5) No No
RESOURCE_CATEGORY VARCHAR(5) No No
RESOURCE_SUB_CAT VARCHAR(5) No No
ANALYSIS_TYPE VARCHAR(3) No No
STATISTICS_CODE VARCHAR(3) No No
TSE_TRIGGER VARCHAR(1) No No
GENERATE_ASN_FLG VARCHAR(1) No No
PICK_RELEASE_ID decimal(10) No No
USE_ROUTE_FLAG VARCHAR(1) No No
BUS_UNIT_BI_TR VARCHAR(5) No No
BILL_SOURCE_TR VARCHAR(10) No No
BILL_TYPE_TR VARCHAR(3) No No
FRT_RULE_CD VARCHAR(10) No No
ALLOW_XFR_INV_FLG VARCHAR(1) No No
BUSINESS_UNIT_AP VARCHAR(5) No No
CUR_RT_TYPE VARCHAR(5) No No
FREIGHT_TERMS VARCHAR(10) No No
FRT_CHRG_METHOD VARCHAR(2) No No
FREIGHT_CALC VARCHAR(1) No No
EXPORT_INT VARCHAR(1) No No
EXPORT_HOLD VARCHAR(1) No No
VALIDATE_ALL VARCHAR(1) No No
AUTO_CLOSE_RCV_FLG VARCHAR(1) No No
AUTO_ROUND_OPT VARCHAR(1) No No
EST_SHIP_ID_SEQ decimal(10) No No
EXPORTER_ECCN VARCHAR(16) No No
EXPORT_LIC_NBR VARCHAR(18) No No
EXT_WHSE_CNTL_FLG VARCHAR(1) No No
WARN_TEMPL_CHG VARCHAR(1) No No
INT_LOC_EXP_RCPT VARCHAR(1) No No
OMBI_DIS_DTL_FLG VARCHAR(1) No No
PENALTY_PROD_ID VARCHAR(18) No No
REBATE_PROD_ID VARCHAR(18) No No
PACK_PARTIAL_FLG VARCHAR(1) No No
ORD_CANCEL_OPT VARCHAR(1) No No
HOLD_CD VARCHAR(6) No No
RESTOCK_PROD_ID VARCHAR(18) No No
SHIP_TO_CUST_ID VARCHAR(15) No No
ADDRESS_SEQ_NUM INT No No
AUTO_PUTAWAY_FLAG VARCHAR(1) No No
RUN_AUTOPTWY_FLAG VARCHAR(1) No No
RMA_BILL_BY_ID VARCHAR(10) No No
REASON_CD_SHIP VARCHAR(10) No No
USE_TMS_KEY_FLG VARCHAR(1) No No
VMI_UNIT_FLG VARCHAR(1) No No
VMI_APPROVAL VARCHAR(1) No No
TRFT_RULE_CD VARCHAR(10) No No
TAX_CD VARCHAR(8) No No
SSRC_ITEM_OPTION VARCHAR(1) No No
SSRC_ITEM_TMPLT VARCHAR(18) No No
BU_FSS_FLG VARCHAR(1) No No
Index
Name Type Unique Member
PS_BUS_UNIT_TBL_IN PK Yes
Member(s) of "PS_BUS_UNIT_TBL_IN" Index
BUSINESS_UNIT

Published June 06, 2007