| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 4 |
DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
|
| 5 |
PAYMENT_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUARED_NONVW
|
| 7 |
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.
Prompt Table:
CUST_SRCH_VW
Set Control Field: BUSINESS_UNIT
|
| 8 |
ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
Prompt Table:
ITEM_ITEM_VW
|
| 9 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
Prompt Table:
ITEM_ITEMLN_VW
|
| 10 |
AR_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
A number that is assigned to draft items to ensure uniqueness of key
|
| 11 |
ITEM_SELECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Item selected switch
Y/N Table Edit
Default Value: N
|
| 12 |
PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 13 |
BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Item Balance
|
| 14 |
ORIG_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Original Balance Amount
|
| 15 |
DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the discount amount available if payment on an item is made before the discount date. The amount is manually entered or system-generated using the payment terms code. The discount date associated with this amount is specified in DISC_DT. This is the first of two possible discounts associated with an item.
|
| 16 |
DISC_ORIG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Original Discount Amount
|
| 17 |
DISC_TAKEN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Taken
|
| 18 |
DISC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Status
E=Earned Discount
N=No Discount
U=Unearned Discount
X=Determine discount status
Default Value: N
|
| 19 |
WS_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Worksheet Sequence Number
|
| 20 |
DISC_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Take Discount
Y/N Table Edit
Default Value: N
|
| 21 |
ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table:
AUTO_ENT_PY_VW
|
| 22 |
ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table:
AUTO_RSN_PY_VW
|
| 23 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 24 |
REF_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Reference Reason
|
| 25 |
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.
|
| 26 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
|
| 27 |
DOCUMENT |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
|
| 28 |
DISC_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the discount amount available if payment on an item is made before the discount date. The amount is manually entered or system-generated using the payment terms code. The discount date associated with this amount is specified in DISC_DT1. This is the second of two possible discounts associated with an item.
|
| 29 |
DISC_DT |
Date(10) |
DATE |
Specifies the date before which payment must be made on an invoice in order to qualify for a discount. This field applies to the first of two possible discounts and is associated with the discount amount specified in DISC_AMT.
|
| 30 |
DISC_DT1 |
Date(10) |
DATE |
Specifies the date before which payment must be made on an invoice in order to qualify for a discount. This field applies to the second of two possible discounts and is associated with the discount amount specified in DISC_AMT1.
|
| 31 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 32 |
DST_ID_AR |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
|
| 33 |
DISC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Specifies the number of days beyond the discount date during which a discount is valid. This defines a discount "grace period".
|
| 34 |
WO_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Write Off Remaining Amount
|
| 35 |
ALLOW_DISC |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies whether or not (Y or N) all discounts for the associated item are to be considered earned even if they have expired.
Y/N Table Edit
Default Value: N
|
| 36 |
DISC_AVAIL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Available
|
| 37 |
SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Prompt Table:
SUBCUST_Q1_TBL
|
| 38 |
SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Prompt Table:
SUBCUST_Q2_TBL
|
| 39 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
Prompt Table:
ITEM_PO_VW
|
| 40 |
PO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.
|
| 41 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 42 |
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.
Prompt Table:
AR_TRMS_VW
|
| 43 |
ASOF_DT |
Date(10) |
DATE |
As of Date
|
| 44 |
ITEM_ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Item Entry Type
|
| 45 |
ITEM_ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Item Entry Reason
|
| 46 |
WO_ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Write Off Entry Type
|
| 47 |
WO_ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
Write Off Entry Reason
|
| 48 |
WO_ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
WO System Function
|
| 49 |
ITEM_ACCTG_DT |
Date(10) |
DATE |
Specifies the accounting date of the original item and appears on subsequent entries. This field is used in multicurrency processing.
|
| 50 |
BAL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code - Bal Amount
|
| 51 |
BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance - Base Currency
|
| 52 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 53 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 54 |
PAY_AMT_ITEM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount - Item Currency
|
| 55 |
RT_TYPE_NEW |
Character(5) |
VARCHAR2(5) NOT NULL |
Current Curncy Exchng Rt Type
|
| 56 |
RATE_MULT_NEW |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Current Rate Multiplier
|
| 57 |
RATE_DIV_NEW |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Current Rate Divisor
Default Value: 1
|
| 58 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 59 |
PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amt - Base Curr
|
| 60 |
REAL_GAIN_LOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the monetary amount of realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
|
| 61 |
DISC_REAL_GAINLOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Real Gain Loss
|
| 62 |
DST_ID_REAL |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
|
| 63 |
WO_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Write Off Amt Base
|
| 64 |
DISC_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt Base Curr
|
| 65 |
WO_AMT_PAY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Write Off Amount Pay
|
| 66 |
DISC_PAY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt Pay
|
| 67 |
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
Prompt Table:
BI_ORD_HDR_VW
|
| 68 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_HDR_ACT_VW
|
| 69 |
PAYMENT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
|
| 70 |
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.
|
| 71 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 72 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
|
| 73 |
VAT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
|
| 74 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 75 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
Y/N Table Edit
|
| 76 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
Prompt Table:
VAT_ENT_REG_VW
|
| 77 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
Prompt Table:
COUNTRY_VAT_VW
|
| 78 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
Prompt Table:
VAT_ENT_REG_VW
|
| 79 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_VAT_VW
|
| 80 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 81 |
VAT_RGSTRN_BUYER |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies a customers VAT Registration ID for a particular country.
|
| 82 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 83 |
NEW_WS_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
New Item Entry
Y/N Table Edit
Default Value: N
|
| 84 |
DD_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process.
|
| 85 |
DD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
|
| 86 |
DD_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency in which a direct debit is created. This field is maintained by the Direct Debit generation process.
|
| 87 |
DD_PROFILE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Profile ID for a Direct Debit
|
| 88 |
DD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process.
A=Accepted
C=Complete
E=Rejected
N=No Action
P=Pending
R=Remitted
Z=All
|
| 89 |
DRAFT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
Prompt Table:
DRAFT_TYPE_TBL
|
| 90 |
CR_ANALYST |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
Prompt Table:
PAY_ANALYST_VW
Set Control Field: BUSINESS_UNIT
|
| 91 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table:
COLLECTOR_SI_VW
|
| 92 |
SALES_PERSON |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
Prompt Table:
SALES_PERSN_VW
|
| 93 |
SALES_PERSON2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Identifies a second Sales Person. Populated on the Item Table to identify an additional Sales Person the Item is applied to.
Prompt Table:
SALES_PERSN_VW
|
| 94 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
REGNCD_MBR_VW
|
| 95 |
DOUBTFUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies items ( or invoices ) which probably will not be paid by the customer. This status is used for items whose balances have been moved from the receivables account to the doubtful account using the transfer worksheet.
|
| 96 |
REVALUE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
Y/N Table Edit
Default Value: Y
|
| 97 |
DRAFT_BUSN_EVENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft.
|
| 98 |
DRAFT_SUB_EVENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Defines specific types of activity that can be performed at the Draft Business Event. For example in the process of approving a Draft you can specify that you are paying an item putting an amount on acccount etc.
|
| 99 |
VAT_ADVPAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT prepayment flag is to indicate if the VAT amount should be calculated on the advance payments
Y/N Table Edit
|
| 100 |
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.
|
| 101 |
VAT_BASIS_AMT_BASE |
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. It is specified in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition of VAT_BASIS_AMT.
|
| 102 |
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.
|
| 103 |
VAT_AMT_BASE |
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. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.
|
| 104 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 105 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 106 |
SBI_NUM |
Character(40) |
VARCHAR2(40) NOT NULL |
SBI_num
|
| 107 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 108 |
ITM_PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
23.3 position signed numeric value. Identifies the item payment amount in the payment's base currency.
|
| 109 |
MRL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Distribution
B=In Balance
E=In Error
N=Not Applied
S=System Generated
|
| 110 |
MRL_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
TAX amount for MRL calculation
|
| 111 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table:
PPRC_PROMO_TBL
|
| 112 |
CLAIM_NO |
Character(30) |
VARCHAR2(30) NOT NULL |
Claim Number for an item
|
| 113 |
CONTROL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
|
| 114 |
CONTROL_CURR_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the base business unit or anchor business unit currency in a worksheet. This currency is used to calculate the control base amount of an item selected in a worksheet.
|
| 115 |
CONTROL_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Used to calculate the control base amount for items selected in receivable worksheets
|
| 116 |
CONTROL_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Used to calculate the control base amount for items selected on receivable worksheets.
Default Value: 1
|
| 117 |
CONTROL_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.
|
| 118 |
DISC_PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount amount in Payment Bas
|
| 119 |
AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
Prompt Table:
AR_SPECIALIST
|
| 120 |
BROKER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Broker ID
Prompt Table:
CUST_BRK_A1S_VW
|
| 121 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 122 |
CLAIM_DT |
Date(10) |
DATE |
Claim Date
|
| 123 |
CLASS_OF_TRADE |
Character(20) |
VARCHAR2(20) NOT NULL |
Class of Trade
|
| 124 |
DEDUCTION_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Deduction Status
C=Closed
I=In Process
O=Created/Opened
W=On Worksheet
Prompt Table:
DEDUCTION_TBL
|
| 125 |
DEDUCTION_DT |
Date(10) |
DATE |
Deduction Date
|
| 126 |
DIVISION |
Character(20) |
VARCHAR2(20) NOT NULL |
Division
|
| 127 |
DT_INVOICED |
Date(10) |
DATE |
Date Invoiced
|
| 128 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 129 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 130 |
INVOICE_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Invoice Business Unit
|
| 131 |
MAJOR_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Classification
|
| 132 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
Prompt Table:
TD_MERCH_TYP_VW
|
| 133 |
PROOF_OF_DELIVERY |
Character(30) |
VARCHAR2(30) NOT NULL |
Proof of Delivery
|
| 134 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 135 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 136 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 137 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
|
| 138 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 139 |
DISPUTE_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the reason that an item or customer is in dispute. For example the dispute status code might represent pricing error.
|
| 140 |
COLLECTION_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
|
| 141 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 142 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 143 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 144 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 145 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 146 |
VAT_SVC_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
|
| 147 |
VAT_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
|
| 148 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 149 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 150 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 151 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 152 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 153 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 154 |
VAT_RPT_CNTRY_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reporting Country Source
1=Ship From
2=Ship To
3=VAT Entity
4=Service Performed Country
5=Supplier Location Country
6=Buyer Location Country
7=Buyer VAT Registration Country
|
| 155 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 156 |
GL_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Level
A=AR Creates GL Acct Entries
B=BI Creates GL Acct Entries
N=No GL Accounting Entries
|
| 157 |
CONVERS_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether a conversation is associated with a single item or with multiple items ."
|
| 158 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
CUST_ADDR_SEQ
|
| 159 |
AG_REF_NBR |
Number(16,0) |
DECIMAL(16) NOT NULL |
Payment Reference Number
|
| 160 |
DISPUTE_DT |
Date(10) |
DATE |
Specifies the date that an item was placed in dispute status.
|
| 161 |
DISPUTE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item.
|
| 162 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 163 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 164 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 165 |
SP_ID |
Number(11,0) |
DECIMAL(11) NOT NULL |
Service Purchase ID
|
| 166 |
AR_TRAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Status
N=Not Applicable
O=Post-Tax
R=Pre-Tax
|
| 167 |
ITEM_MSG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Item Message Code
CNL=Cancel Item
CRT=Create Open Item
GBA=Goal Balance Attained
RFD=Refund Item
|
| 168 |
STX_TAX_AUTH_RATE |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Authority Rate (India Sales Tax)
|
| 169 |
STX_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Tax Calculation Code
|