INSTALLATION_AP(SQL Table) |
Index Back |
|---|---|
Installation AP OptionsInstallation AP Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AP_IU_ACCT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
AP InterUnit Options
D=Direct InterUnit Accounting I=Indirect InterUnit Accounting Default Value: I |
| 2 | POSTING_METHOD_AP | Character(1) | VARCHAR2(1) NOT NULL |
Posting Method
D=Detail Offset Method S=Summary Control Default Value: S |
| 3 | SCHEDULE_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Schedulepaymentflag
Y/N Table Edit Default Value: N |
| 4 | LAST_PAY_SCHED_NBR | Number(7,0) | INTEGER NOT NULL | Last schedule ID number |
| 5 | LATE_CHRG_GEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Late Charge
Y/N Table Edit Default Value: N |
| 6 | HURDLE_RT_CALC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Evaluate Discount Rate
Y/N Table Edit Default Value: N |
| 7 | SCHED_MAN_FR_NBR | Number(7,0) | INTEGER NOT NULL | Manual Start Number |
| 8 | SCHED_MAN_TO_NBR | Number(7,0) | INTEGER NOT NULL | End Number |
| 9 | SCHED_OTH_FR_NBR | Number(7,0) | INTEGER NOT NULL | Other Start Number |
| 10 | SCHED_OTH_TO_NBR | Number(7,0) | INTEGER NOT NULL | End Number |
| 11 | SCHED_TRN_FR_NBR | Number(7,0) | INTEGER NOT NULL | Transportation Start Number |
| 12 | SCHED_TRN_TO_NBR | Number(7,0) | INTEGER NOT NULL | End Number |
| 13 | LST_MAN_NBR | Number(7,0) | INTEGER NOT NULL | Last Schedule ID Number |
| 14 | LST_OTH_NBR | Number(7,0) | INTEGER NOT NULL | Last Schedule ID Number |
| 15 | LST_TRN_NBR | Number(7,0) | INTEGER NOT NULL | Last Schedule ID Number |
| 16 | DATE_CALC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Date Calc Basis
Y/N Table Edit Default Value: N |
| 17 | AP_DWNWRDADJST | Character(1) | VARCHAR2(1) NOT NULL |
Edit For Prior Yr Encumbrance
Y/N Table Edit Default Value: N |
| 18 | CCR_ENABLED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
CCR - Central Contractor Registry Functionality Enabled Flag
Y/N Table Edit Default Value: N |
| 19 | CCR_SIC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use SIC code functionality flag
Y/N Table Edit Default Value: N |
| 20 | CCR_NAICS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use delivered NAICS code functionality flag
Y/N Table Edit Default Value: N |
| 21 | ASSTN_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Document Association Group
Default Value: DEFAULT Prompt Table: AP_ASSTN_GRP |
| 22 | OFAC_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Federal Sanctions edit option
B=Enabled at Bank I=Enabled at Installation N=No validation Default Value: N |
| 23 | ENABLE_DCM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Document Content Management Invoice Integration
Y/N Table Edit Default Value: N |
| 24 | DCM_URL_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Document Url construction method
A=Application Package C=URL included in invoice data G=URL Definition + Document ID N=3rd party solution-No link Default Value: G |
| 25 | DCM_URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier
Prompt Table: PSURLDEFN |
| 26 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: DCM_PACKAGE_VW |
| 27 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL | Qualified Package/Class Path |
| 28 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
| 29 | APPCLASSMETHOD | Character(60) | VARCHAR2(60) NOT NULL | Application Class Method Name |
| 30 | ENABLE_MCF | Character(1) | VARCHAR2(1) NOT NULL |
Enable Match Collaboration Feature
Y/N Table Edit Default Value: N |
| 31 | AP_MECC_PUSH | Character(1) | VARCHAR2(1) NOT NULL |
Enable Push Notifications
Y/N Table Edit Default Value: N |
| 32 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 33 | RPTG_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Reporting Currency
Prompt Table: CURRENCY_CD_TBL |