BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Y/N Table Edit
Default Value: Y
A=Automatic Generate
N=None
S=Stage
Default Value: N
Y/N Table Edit
Default Value: Y
BU_AP_DIAG_VW(SQL View) |
Index Back |
|---|---|
AP Business Unit Definition |
| SELECT BUSINESS_UNIT , POST_UNMATCH_FLG , VCHR_MTCH_ADJ_OPT , ASSTN_ALG_NAME , RECEIPT_DELAY_DAYS , MTCH_ADJ_DELAY_DAY , MATCH_APPRV_FLG , COPYTO_GROSS_AMT FROM PS_BUS_UNIT_TBL_AP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | POST_UNMATCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Post Unmatched Vouchers
Y/N Table Edit Default Value: Y |
| 3 | VCHR_MTCH_ADJ_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Match Exception Adjustment Opt
A=Automatic Generate N=None S=Stage Default Value: N |
| 4 | ASSTN_ALG_NAME | Character(15) | VARCHAR2(15) NOT NULL | Document Association |
| 5 | RECEIPT_DELAY_DAYS | Number(3,0) | SMALLINT NOT NULL | Receipt Delay Days |
| 6 | MTCH_ADJ_DELAY_DAY | Number(3,0) | SMALLINT NOT NULL | Match Adjust Delay Days |
| 7 | MATCH_APPRV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Matching for Voucher Approval
Y/N Table Edit Default Value: Y |
| 8 | COPYTO_GROSS_AMT | Character(1) | VARCHAR2(1) NOT NULL | Copy Gross Amount to Voucher |