| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
STATERECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
AE default state record name
|
| 3 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 6 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 7 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 8 |
TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount (base)
|
| 9 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 10 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 11 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 12 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
|
| 13 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 14 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 15 |
TO_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
|
| 16 |
START_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Starting Invoice Number
|
| 17 |
END_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Ending Invoice Number
|
| 18 |
STARTING_DT |
Date(10) |
DATE |
Bills Added On or After
|
| 19 |
INVOICE_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Action
C=Reprint
I=Invoice
P=Pro Forma
|
| 20 |
CONSOLIDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate Headers
|
| 21 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 22 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 23 |
INVOICE_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Date Option
P=Processing Date
U=User Defined
|
| 24 |
DIST_EDI |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute EDI Bills
|
| 25 |
INVOICE_RANGE_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Range Option
ALI=All Invoiced Bills
ALL=All
CUS=Cust ID
CYC=Bill Cycle
DT=Date Bill Added
DTI=Date
GRP=Copy Group ID
INV=Invoice ID
MUL=Multi-Select Table
PVN=Public Voucher Number
RGP=Reprint Group
SEL=Range ID
SHP=Ship ID
SRC=Bill Source
TYP=Bill Type
|
| 26 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
|
| 27 |
RANGE_SELECTION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Range Selection ID
|
| 28 |
SQL_STMT_800 |
Long Character(800) |
VARCHAR2(800) |
SQL_Stmt_800
|
| 29 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 30 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 31 |
EDI_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
EDI Invoice Options
1=EDI Only
2=EDI and Print
3=Print Only
|
| 32 |
BUS_UNIT_EXP |
Character(8) |
VARCHAR2(8) NOT NULL |
Business Unit Expression
Default Value: =
|
| 33 |
ACTION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Flag
A=Action
|
| 34 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 35 |
BASIS_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Terms Basis Day
|
| 36 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 37 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 38 |
SETID1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID Value
|
| 39 |
SETID2 |
Character(5) |
VARCHAR2(5) NOT NULL |
2nd SetId
|
| 40 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 41 |
INVOICE_AMT_PRETAX |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 42 |
INVOICE_PRETAX_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 43 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 44 |
INVOICE_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 45 |
VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
|
| 46 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 47 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
|
| 48 |
MESSAGE_SEQ |
Number(9,0) |
DECIMAL(9) NOT NULL |
Message Sequence
|
| 49 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 50 |
BI_RECCOUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
BI Rec Count
|
| 51 |
TEMP_DT |
Date(10) |
DATE |
Temp Date
|
| 52 |
ERROR_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Error Type
ERR=Stop
NON=None
WAR=Warning
|
| 53 |
ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 54 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 55 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 56 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 57 |
ACTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Broadcast
D=log Deletedsequence number
E=Check doc seq enable option
G=Generate sequence number
R=Reset for 1099C Submission
X=Deleted from 1099C Prep Table
|
| 58 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 59 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 60 |
FIELDNAME_ACCTDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Accounting Date field name
|
| 61 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
|
| 62 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 63 |
WHERE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Where Option
B=Both
N=None
P=Process Instance
V=By Value
|
| 64 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 65 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 66 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 67 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 68 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 69 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 70 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 71 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
|
| 72 |
FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
|
| 73 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
|
| 74 |
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.
|
| 75 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 76 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 77 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 78 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 79 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 80 |
RND_ADJ |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Rounding Adjustment
|
| 81 |
BUSINESS_UNIT_SRCH |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit for Search
|
| 82 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 83 |
INVOICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
|
| 84 |
INVOICE_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Invoice Day
|
| 85 |
BU_BLANK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Blank Business Unit Flag
|
| 86 |
DEBUG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Debug Swt
|
| 87 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
|
| 88 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 89 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
|
| 90 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
|
| 91 |
PREV_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Business Unit
|
| 92 |
DUE_DATE_WRK |
Date(10) |
DATE |
Due Date
|
| 93 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 94 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 95 |
DTTM_FROM |
DateTime(26) |
TIMESTAMP |
From Date/Time
|
| 96 |
EXD_CONVERSION_RT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 97 |
EXD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Tax Amount
|
| 98 |
EXD_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 99 |
EXS_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount
|
| 100 |
EXS_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount Base Currency
|
| 101 |
EXS_BASIS_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount Reporting Currency
|
| 102 |
EXS_TAXRT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 103 |
EXS_TAXRT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 104 |
EXS_TAXRT_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 105 |
EXS_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount
|
| 106 |
EXS_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Base Currency
|
| 107 |
EXS_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Reporting Currency
|
| 108 |
EXS_TAX_RATE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Tax Rate Sequence
|
| 109 |
EXS_TAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Type
C=Custom Duty
E=Excise Duty
G=Goods and Services Tax
S=Sales Tax / VAT
|
| 110 |
EXS_TXC_LN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
|
| 111 |
EXS_TXC_DTL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
|
| 112 |
QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity
|
| 113 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 114 |
STX_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 115 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 116 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 117 |
DS_PY_TRMS_TIME_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Discount Timing
|
| 118 |
DSCNT_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Discount Percentage
|
| 119 |
VAT_DCLRTN_DT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Declaration Date Source
A=Delivery Date - Ext Process
D=Delivery Date - Txn Entry
I=Invoice Date
M=Manual Entry
N=Not Applicable
|
| 120 |
VAT_DCLRTN_DT |
Date(10) |
DATE |
"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
|
| 121 |
VAT_RGSTRN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT Registration ID
|
| 122 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 123 |
VAT_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculated Amount
|
| 124 |
VAT_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculated Amount Base Cur
|
| 125 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
|
| 126 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 127 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 128 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 129 |
VAT_TRANS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount in base currency against which the VAT is applicable
|
| 130 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount in Base Curr
|
| 131 |
VAT_CALC_LINE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculation Line Amount
|
| 132 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 133 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
|
| 134 |
T_VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Basis Amount
|
| 135 |
T_VAT_BASIS_AMTBSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Basis Amount Base
|
| 136 |
T_VAT_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Calculated Amount
|
| 137 |
T_VAT_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Calculated Amt Base
|
| 138 |
DIFF1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Difference
|
| 139 |
DIFF2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Difference
|
| 140 |
DIFF3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Difference
|
| 141 |
DIFF4 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Difference
|
| 142 |
TAX_PCT |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Tax Percent
|
| 143 |
FIRST_AUTO_NBR |
Number(18,0) |
DECIMAL(18) NOT NULL |
First Number in Range
|
| 144 |
AG_REF_SEQ |
Number(15,0) |
DECIMAL(15) NOT NULL |
Payment Reference Sequence
|
| 145 |
AG_REF_NBR |
Number(16,0) |
DECIMAL(16) NOT NULL |
Payment Reference Number
|
| 146 |
LAST_AUTO_NBR |
Number(18,0) |
DECIMAL(18) NOT NULL |
Last Auto-Assigned Number
|
| 147 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 148 |
BUS_UNIT_LOOP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Looping Option Flag
|
| 149 |
BUSINESS_UNIT_SEL |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit entered as a run time parameter when executing the automat
|
| 150 |
BU_WHERE_CLAUSE |
Character(50) |
VARCHAR2(50) NOT NULL |
Open Liability Where Clause.
|
| 151 |
BU_WHERE_CLAUSE1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Open Liability Where Clause.
|
| 152 |
LOOP_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Number of Program Loops
|
| 153 |
LINE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing
BAE=Billed Amount in Excess
BRT=Billing Retainage
DAPP=Cust Deposit Applied
DEP=Customer Deposit
DISC=Discount Line
DREF=Cust Deposit Refunded
DRFF=Cust Deposit Refund Fee
FRGT=Freight (Surcharge)
MISC=Miscellaneous Charge
PYCV=Payment with Corporate Voucher
RAE=Reclaimed Amount in Excess
REV=Revenue Line
RSTK=Restock (Surcharge)
SUR=Surcharge Line
UTL=Utilization Line
|
| 154 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
|
| 155 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 156 |
EMAIL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Email Notification Options
1=Email Only
2=Email & Print
3=Print Only
|
| 157 |
EMAIL_IVC_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Email Invoice Options
1=Email Only
2=Email & Print
3=Print Only
|
| 158 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 159 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 160 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 161 |
SOURCE_REF_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Generice reference type
001=CRM Agreement
002=CRM Case
003=CRM Order
004=CRM Service Order
005=Accounts Receivable
006=Billing
007=Order Management
|
| 162 |
PARENT_PROGRAM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Parent Program ID
|
| 163 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 164 |
PROC_ONLINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Online
Default Value: N
|
| 165 |
START_PVN |
Number(6,0) |
INTEGER NOT NULL |
Starting Public Voucher Number
|
| 166 |
END_PVN |
Number(6,0) |
INTEGER NOT NULL |
Ending Public Voucher Number
|
| 167 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 168 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 169 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 170 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 171 |
FED_FILE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Highway File Options
1=File Only
2=File and Print
|
| 172 |
EIVC_FILE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Invoice File Options
1=Xml Only
2=Xml and Print
3=Print Only
|
| 173 |
EIVC_COPY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
E-Invoice Copy Indicator
N=Original Elec Invoice File
O=Cannot Generate EIVC File
Y=Copy Electronic Invoice File
|
| 174 |
VAT_RVRSE_CHG_GDS |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reverse Charge goods flag
Y/N Table Edit
|
| 175 |
TAX_CD_VAT_RVC |
Character(8) |
VARCHAR2(8) NOT NULL |
Reverse Charge VAT Code
|
| 176 |
TAX_CD_VAT_RVC_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Customer VAT Rate
|
| 177 |
VAT_AMT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reverse Charge VAT Amount
|
| 178 |
VAT_AMT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reverse Charge Amount in Base Currency
|
| 179 |
T_VAT_AMT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cust VAT Calculated Amt
|
| 180 |
T_VAT_AMT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cust VAT Basis Amount
|
| 181 |
DIFF5 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Difference
|
| 182 |
DIFF6 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Difference
|
| 183 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 184 |
GST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Goods and Services Tax
|
| 185 |
ERROR_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error Count
|
| 186 |
SQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|