|
SELECT A.GROUP_BU , A.GROUP_ID , B.SETID , A.BUSINESS_UNIT , A.CUST_ID , A.ITEM , A.ITEM_LINE , A.GROUP_SEQ_NUM , A.ENTRY_TYPE , A.ENTRY_REASON , A.ENTRY_AMT , A.ACCOUNTING_DT , A.ASOF_DT , A.POST_DT , A.DUE_DT , A.CR_ANALYST , A.SALES_PERSON , A.COLLECTOR , A.DISPUTE_STATUS , A.DISPUTE_DT , A.DISPUTE_AMOUNT , A.PO_REF , A.PO_LINE , A.DOCUMENT , A.DOCUMENT_LINE , A.POSTED_FLAG , A.PYMNT_TERMS_CD , A.DISC_AMT , A.DISC_AMT1 , A.DISC_DT , A.DISC_DT1 , A.DISC_DAYS , A.DUE_DAYS , A.ALLOW_DISC , A.DST_ID_AR , A.DUN_DT , A.ST_DT , A.FC_DT , A.FC_AMT , A.AR_ERROR_CD , A.ENTRY_USE_ID , A.DST_BAL_ITEM , A.COLLECTION_STATUS , A.COLLECTION_DT , A.BILL_OF_LADING , A.SUBCUST_QUAL1 , A.SUBCUST_QUAL2 , A.ENTRY_CURRENCY , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.PAYMENT_AMT , A.PAYMENT_CURRENCY , A.ENTRY_AMT_BASE , A.CURRENCY_CD , A.REAL_GAIN_LOSS , A.DST_ID_REAL , A.ITEM_ACCTG_DT , A.VAT_ENTITY , A.VAT_CALC_GROSS_NET , A.VAT_DCLRTN_POINT , A.VAT_RECALC_FLG , A.VAT_BASIS_AMT , A.VAT_BASIS_AMT_BASE , A.VAT_AMT , A.VAT_AMT_BASE , A.COUNTRY_VAT_BILLFR , A.COUNTRY_VAT_BILLTO , A.COUNTRY_SHIP_TO , A.ORDER_NO , A.CONTRACT_NUM , A.BUSINESS_UNIT_BI , A.BUSINESS_UNIT_OM , A.ADDRESS_SEQ_NUM , A.LETTER_CD , A.CONSOL_BUS_UNIT , A.CONSOL_INVOICE , A.PAYMENT_METHOD , A.DRAFT_BU , A.DRAFT_ID , A.DRAFT_APPROVAL , A.DRAFT_DOC , A.DRAFT_CURRENCY , A.DRAFT_FORMAT , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PROCESS_INSTANCE , A.USER_AMT1 , A.USER_AMT2 , A.USER_AMT3 , A.USER_AMT4 , A.USER_AMT5 , A.USER_AMT6 , A.USER_AMT7 , A.USER_AMT8 , A.USER_DT1 , A.USER_DT2 , A.USER_DT3 , A.USER_DT4 , A.USER1 , A.USER2 , A.USER3 , A.USER4 , A.USER5 , A.USER6 , A.USER7 , A.USER8 , A.USER9 , A.USER10 , VAT_TREATMENT_GRP , PHYSICAL_NATURE , COUNTRY_LOC_BUYER , STATE_LOC_BUYER , COUNTRY_LOC_SELLER , STATE_LOC_SELLER , VAT_SVC_SUPPLY_FLG , VAT_SERVICE_TYPE , COUNTRY_VAT_PERFRM , STATE_VAT_PERFRM , COUNTRY_VAT_SUPPLY , STATE_VAT_SUPPLY , STATE_SHIP_FROM , STATE_SHIP_TO , VAT_RPT_CNTRY_SRC , STATE_VAT_DEFAULT , DISC_TAKEN , GL_LVL , ITEM_LINE_ORIG , TOT_TAX_AMT , TOT_TAX_AMT_BSE , TOT_EXD_AMT , TOT_EXD_AMT_BSE , TOT_STX_AMT , TOT_STX_AMT_BSE , AR_IU_REQ , A.BUSINESS_UNIT_CA , A.CONTRACT_LINE_NUM , A.SUBROG_CASE_NUM , A.SP_ID FROM PS_PENDING_ITEM A , PS_SET_CNTRL_REC B WHERE B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.RECNAME = 'CUSTOMER'
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GROUP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
Default Value: GROUP_CONTROL.GROUP_BU
Prompt Table:
SP_BUARED_NONVW
|
| 2 |
GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
Default Value: GROUP_CONTROL.GROUP_ID
Prompt Table:
GROUP_CONTROL
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: GROUP_CONTROL.GROUP_BU
Prompt Table:
BU_EFFDT_VW_AR
|
| 5 |
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_BI_A2_VW
|
| 6 |
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.
|
| 7 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 8 |
GROUP_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
|
| 9 |
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:
ITEM_ENTRY_VW
|
| 10 |
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:
ITEM_REASON_TBL
|
| 11 |
ENTRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the monetary amount of a pending item transaction such as invoice or credit memo.
|
| 12 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: GROUP_CONTROL.ACCOUNTING_DT
|
| 13 |
ASOF_DT |
Date(10) |
DATE NOT NULL |
As of Date
Default Value: PENDING_ITEM.ACCOUNTING_DT
|
| 14 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
|
| 15 |
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.
|
| 16 |
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:
CR_ANALYST_TBL
|
| 17 |
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_TBL
|
| 18 |
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_TBL
|
| 19 |
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.
Prompt Table:
DISPUTE_TBL
|
| 20 |
DISPUTE_DT |
Date(10) |
DATE |
Specifies the date that an item was placed in dispute status.
|
| 21 |
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.
|
| 22 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 23 |
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.
|
| 24 |
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.
|
| 25 |
DOCUMENT_LINE |
Number(6,0) |
INTEGER NOT NULL |
Specifies the line number of a Document ID used as a reference on a Receivables item.
|
| 26 |
POSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
Y/N Table Edit
Default Value: N
|
| 27 |
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
|
| 28 |
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.
|
| 29 |
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.
|
| 30 |
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.
|
| 31 |
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.
|
| 32 |
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".
|
| 33 |
DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
"Specifies the number of days beyond the due date for which payment is still considered on time. This defines a payment ""grace period""."
|
| 34 |
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
|
| 35 |
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.
Prompt Table:
DST_CODE_AR_VW
|
| 36 |
DUN_DT |
Date(10) |
DATE |
Specifies the date that a dunning letter is sent. This date is generated by the Dunning SQR.
|
| 37 |
ST_DT |
Date(10) |
DATE |
Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.
|
| 38 |
FC_DT |
Date(10) |
DATE |
Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
|
| 39 |
FC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
|
| 40 |
AR_ERROR_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Error code field assigned by AR Update.
|
| 41 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
|
| 42 |
DST_BAL_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the accounting entries for a receivables item are in balance. This field is maintained by the system.
I=Complete
N=Not Applicable
O=Incomplete
|
| 43 |
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.
Prompt Table:
COLLECTION_TBL
|
| 44 |
COLLECTION_DT |
Date(10) |
DATE |
Specifies the date that a customer or invoice was put in collection status. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
|
| 45 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 46 |
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
|
| 47 |
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
|
| 48 |
ENTRY_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency associated with the monetary amount of a pending item.
Prompt Table:
ENT_CUR_CD_VW
|
| 49 |
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
|
| 50 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 51 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 52 |
PAYMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a customer payment.
|
| 53 |
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.
|
| 54 |
ENTRY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the monetary amount of a pending item transaction such as invoice or credit memo in the base currency of the business unit.
|
| 55 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 56 |
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).
|
| 57 |
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).
|
| 58 |
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.
|
| 59 |
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.
|
| 60 |
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
|
| 61 |
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
|
| 62 |
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.
|
| 63 |
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.
|
| 64 |
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.
|
| 65 |
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.
|
| 66 |
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.
|
| 67 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
|
| 68 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
|
| 69 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
|
| 70 |
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
|
| 71 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 72 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 73 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 74 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
CUST_ADDR_SEQ
|
| 75 |
LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies a type of correspondence used for follow-up letters or dunning notices. A letter code is associated with a customizable template to facilitate form letters.
Prompt Table:
LTR_CD_DUN_VW
|
| 76 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 77 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 78 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
|
| 79 |
DRAFT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
|
| 80 |
DRAFT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.
|
| 81 |
DRAFT_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
P=Preapproved
R=Approval Required
|
| 82 |
DRAFT_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. "
C=Create Document
N=Do Not Create Document
|
| 83 |
DRAFT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.
|
| 84 |
DRAFT_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether a draft will be associated with a single item or with multiple items. This field is used only when the payment method is ""draft""."
M=Multiple Items Per Draft
S=Single Item Per Draft
|
| 85 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 86 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 87 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 88 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 89 |
USER_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 90 |
USER_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 91 |
USER_AMT3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 92 |
USER_AMT4 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 93 |
USER_AMT5 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 94 |
USER_AMT6 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 95 |
USER_AMT7 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 96 |
USER_AMT8 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 97 |
USER_DT1 |
Date(10) |
DATE |
Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4).
|
| 98 |
USER_DT2 |
Date(10) |
DATE |
Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4).
|
| 99 |
USER_DT3 |
Date(10) |
DATE |
Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4).
|
| 100 |
USER_DT4 |
Date(10) |
DATE |
Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4).
|
| 101 |
USER1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 102 |
USER2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 103 |
USER3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 104 |
USER4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 105 |
USER5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 106 |
USER6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 107 |
USER7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 108 |
USER8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 109 |
USER9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 110 |
USER10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 111 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 112 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 113 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 114 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 115 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 116 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 117 |
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
|
| 118 |
VAT_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
|
| 119 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 120 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 121 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 122 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 123 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 124 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 125 |
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
|
| 126 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 127 |
DISC_TAKEN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Taken
|
| 128 |
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
|
| 129 |
ITEM_LINE_ORIG |
Number(6,0) |
INTEGER NOT NULL |
Original OC Item Line
|
| 130 |
TOT_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Tax Amount
|
| 131 |
TOT_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Tax Amt Base
|
| 132 |
TOT_EXD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Excise Amount
|
| 133 |
TOT_EXD_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Excise Amount Base
|
| 134 |
TOT_STX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total ST/VAT Amount
|
| 135 |
TOT_STX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Sales Tax Amount Base
|
| 136 |
AR_IU_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by AR to see if IntraUnit entries are required after a user modifies a ChartField online. This flag is checked by PGG to see if it should call the IU processor.
|
| 137 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 138 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 139 |
SUBROG_CASE_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Subrogation case number used for Insurance
|
| 140 |
SP_ID |
Number(11,0) |
DECIMAL(11) NOT NULL |
Service Purchase ID
|