Populating Pending Item Table Fields

The PS_PENDING_ITEM table is a child of the PS_GROUP_CONTROL table. It contains one record for each transaction that you add to the system. A pending item may represent any kind of invoice, debit memo, credit memo, or adjustment. During conversion, or in a specialized payment interface application, a pending item may also represent a payment.

The following table lists the appropriate values for each field in the PS_PENDING_ITEM table. Many of the fields are optional, and some are used only by the system processes.

The following table specifies a field type for each field in the PS_PENDING_ITEM_table. Use the field type to determine how to populate system-maintained fields and optional fields that you want to leave blank. Supply a space for a character field, a null value for a date field, and a zero for a numeric field.

Note:

Use Application Designer to review the characteristics of each field in more detail.

Column	Field Name	Field Type	Optional/ Conditional/ Required	Field Description
1	GROUP_BU	Character	Required	Enter the same value as the GROUP_ BU on PS_GROUP_CONTROL.
2	GROUP_ID	Character	Required	Enter the same value as the GROUP_ID on PS_GROUP_CONTROL.
3	BUSINESS_UNIT	Character	Required	Enter the business unit that is associated with the customer account to which you post the pending item. It may be the same as, or different from, GROUP_BU.
4	CUST_ID	Character	Required	Enter the customer identifier.
5	ITEM	Character	Required	Enter the item identifier.
6	ITEM_LINE	Number	Optional	Enter PeopleSoft Receivables at a line-item level of detail.
7	GROUP_SEQ_NUM	Number	Optional	If you bring in more than one row for a single BUSINESS_UNIT, CUST_ID, ITEM, and ITEM_LINE combination, you must populate this field; otherwise, enter 0. An example of why you would bring in more than one row for a single item (BUSINESS_UNIT, CUST_ID, ITEM and ITEM_LINE combination) is that your billing system or conversion program is sending an invoice and credit memo for a single item that is in the same group. You have two options for populating this field: Assign a unique number to each pending item in the group. PeopleSoft Receivables does this for online group item entry. Assign a value only for pending items that are repeated in the group, and enter a 0 in the field for pending items that are not repeated in the group.
8	ENTRY_TYPE	Character	Required	Select the type of item that is being processed. Select from the entry types that you establish in the PS_ENTRY_ TYPE_TBL that are enabled for the IT-01 or IT-02 system functions.
9	ENTRY_REASON	Character	Optional	Enter an optional reason to further qualify the entry type. You can set up entry types in the system to require entry reasons. Select from the entry reasons that you establish in the PS_ENTRY_ REASN_TBL that are enabled for the IT-01 or IT-02 system functions.
10	ENTRY_AMT	Number	Required	Enter the amount of the entry in the entry currency. This amount cannot be 0.
11	ENTRY_EVENT	Character	Optional	Enter the code that the federal government uses to post pro-forma accounting information. The Entry Event Generator generates supplemental accounting lines if you enter this code.
12	ACCOUNTING_DT	Date	Required	Enter the date that determines the processing period for the Receivables Update process and accounting entries.
13	ASOF_DT	Date	Required	Enter an optional date for use in conversion or ongoing interface. Payment terms and aging calculations may be based on the value that is in this field. Use the same value as the ACCOUNTING_DT if you do not supply a separate value.
14	POST_DT	Date	Optional	The Receivables Update process updates this date.
15	DUE_DT	Date	Optional	Enter the due date of the item. Every pending item must have a due date or a payment terms code. For pending items that may represent subsequent activity against an original invoice, such as a credit memo, the due date field is not used in processing. However, it must contain a value.
16	CR_ANALYST	Character	Optional	Select an assignment of this pending item to a credit analyst. Select from the values that you establish in the PS_CR_ANALYST_ TBL or enter a space. If you enter a space, the Receivables Update process adds the default value from PS_CUSTOMER.
17	SALES_PERSON	Character	Optional	Select an assignment of this item to a team member. Select from the values that you establish in the PS_TEAM_MEMBERS, or enter a space. If you enter a space, the Receivables Update process adds the default value from PS_CUSTOMER.
18	COLLECTOR	Character	Optional	Select an assignment of this item to a collector. Select from the values that you establish in the PS_COLLECTOR_TBL or enter a space. If you enter a space, the Receivables Update process adds the default value from PS_CUSTOMER.
19	DISPUTE_STATUS	Character	Optional	Indicates if the item is in dispute. A possible use for this field is to carry over an existing dispute indication during conversion. Select from the values that you establish in the PS_DISPUTE_TBL.
20	DISPUTE_DT	Date	Optional	Enter the date associated with the dispute status indicator.
21	DISPUTE_AMOUNT	Sign	Optional	Enter the Amount associated with the dispute status indicator.
22	PO_REF	Character	Optional	Enter the purchase order associated with the item.
23	PO_LINE	Number	Optional	Enter the line number for the purchase order.
24	DOCUMENT	Character	Optional	Enter a reference number for the item.
25	DOCUMENT_LINE	Number	Optional	Enter a line number for the document reference.
26	POSTED_FLAG	Character	Required	Set to N (not posted). The Receivables Update process maintains this field.
27	PYMNT_TERMS_CD	Character	Optional	Enter a due date or payment terms code. Select from the values that you establish on PS_PAY_TRMS_TBL for accounts receivable. If you do not supply a value, enter a space. If you enter a space and do not provide a due date, the Receivables Update process uses the default that you establish for the customer or business unit options.
28	DISC_AMT	Number	Optional	Enter the first discount amount that is available if the payment accounting date is on or before the discount date. You may enter this or let the payment terms module calculate it. You cannot have a discount amount if you entered a payment terms code. Enter a value only if you are also entering the due date. A value is required if you have supplied the discount date.
29	DISC_AMT1	Number	Optional	Enter the second discount amount that is available if payment accounting date is on or before the discount date. You may enter this or let the payment terms module calculate it. You cannot have a discount amount if you entered a payment terms code. Enter a value only if you are also entering the due date. A value is required if you have supplied the discount date.
30	DISC_DT	Date	Optional	Enter the date associated with DISC_AMT.
31	DISC_DT1	Date	Optional	Enter the date associated with DISC_AMT1.
32	DISC_DAYS	Number	Optional	Enter the discount grace days that are associated with the item. If you do not supply a value, enter 0. If you enter 0, the Receivables Update process uses the default value from the customer or business unit level.
33	DUE_DAYS	Number	Optional	Enter the due grace days that are associated with the item. If you do not supply a value, enter a 0. If you enter 0, the Receivables Update process uses the default value from the customer or business unit level.
34	ALLOW_DISC	Character	Required	Set value to Y if you want the system to consider all discounts for this pending item as earned even if they are expired. Entering N enables normal discount processing. This field is useful for handling special invoice situations or, during conversion, to indicate that special instructions are already recorded. The Application Designer default for online processing is N.
35	DST_ID_AR	Character	Optional	If you populate PS_PENDING_DST in your billing interface, enter a space. If you plan to generate accounting entries during the Receivables Update process, you must supply a value. Select from the values that you defined for accounts receivable in the PS_DST_CODE_TBL.
36	DUN_DT	Date	Optional	The Dunning Application Engine process (AR_DUNNING) maintains this date.
37	ST_DT	Date	Optional	The Statements Application Engine process (AR_STMTS) maintains this date.
38	FC_DT	Date	Optional	The Overdue Charge Application Engine process (AR_OVRDUE) maintains this date.
39	FC_AMT	Sign	Optional	The Overdue Charge process maintains this amount.
40	OC_ADMIN_DT	Date	Optional	The Overdue Charge process maintains this date.
41	OC_ADMIN_AMT	Sign	Optional	The Overdue Charge process maintains this amount.
42	OC_PNLTY_DT	Date	Optional	The Overdue Charge process maintains this date.
43	OC_PNLTY_AMT	Sign	Optional	The Overdue Charge process maintains this amount.
44	OVERDUE_CHG_LINE	Character	Options	The Overdue Charge process maintains this value.
45	AR_ERROR_CD	Character	Optional	The Receivables Update process maintains the AR_ERROR_CD.
46	ENTRY_USE_ID	Character	Optional	Select the system-defined field that determines the type of processing that is associated with an entry type. Select IT-01 (Create an Invoice/Debit Memo) for a positive amount. Select IT-02 (Create a Credit Memo) for a negative amount. Make sure that you correctly match the entry types with the system function that represents the sign of the amount on the pending item.
47	DST_BAL_ITEM	Character	Required	Indicates if the accounting entries for the item are in balance. Enter O unless you provide your own PS_PENDING_ DST rows. If you provide your own rows, enter I. The Receivables Update process does not balance accounting entries that are supplied by an interface.
48	COLLECTION_STATUS	Character	Optional	Indicates if the item is in collection. Select from the values that you established in the PS_COLLECTION_TBL. This field may be used during conversion when the existing system marks items in this manner.
49	COLLECTION_DT	Date	Optional	Enter the date associated with the collection status.
50	BILL_OF_LADING	Character	Optional	Enter a bill of lading for the item.
51	SUBCUST_QUAL1	Character	Optional	Enter a value for the first subcustomer field for the item (if required). Select from the values that you established in the PS_SUBCUST_ Q1_TBL.
52	SUBCUST_QUAL2	Character	Optional	Enter a value for the second subcustomer field for the item (if required). Select from the values that you established in PS_SUBCUST_ Q2_TBL.
53	ENTRY_CURRENCY	Character	Required	Enter the currency code for the entry amount. Select from the values that you establish on PS_CURRENCY_CD_ TBL. If you provide a value for CONTROL_CURRENCY on PS_ GROUP_CONTROL, you must use the same value here.
54	RT_TYPE	Character	Optional	Enter the exchange rate type for the item. Required if the entry currency is different from the business unit base currency. Select from the values that are established on PS_CUR_RT_ TYPE_TBL or enter a space.
55	RATE_MULT	Number	Optional	Enter the ______________. This value is required if the entry currency is different from the business unit base currency.
56	RATE_DIV	Number	Optional	Enter the ______________. This value is required if the entry currency is different from the business unit base currency.
57	PAYMENT_AMT	Number	Optional	Enter 0.
58	PAYMENT_CURRENCY	Character	Optional	Enter a space.
59	ENTRY_AMT_BASE	Number	Optional	Enter the amount of the pending item that is denominated in the business unit base currency. If you populate this field, the assumption is that you have performed currency conversion. You should enter a value in the field that is equal to ENTRY_AMT multiplied by RATE_DIV and RATE_MULT. You must also enter values in the RATE_DIV and RATE_MULT fields. If you are populating PS_PENDING_DST in your interface, you may enter a 0 in this field. The Receivable Update computes ENTRY_AMT_BASE by using ENTRY_AMT, RATE_DIV, and RATE_MULT. If you create accounting entries during the Receivables Update process, you must supply a value for this field. In other words, you must perform currency conversion before or while populating PS_PENDING_ITEM to create accounting entries during the Receivables Update process.
60	CURRENCY_CD	Character	Required	Enter the base currency of the business unit that is associated with the item. Be sure that this value matches the value that you established for the PeopleSoft General Ledger business unit that corresponds to the Accounts Receivable business unit.
61	REAL_GAIN_LOSS	Number	Optional	Enter a realized gain or loss value that the system calculates during payment application or for a maintenance worksheet.
62	DST_ID_REAL	Character	Optional	Enter the distribution ID for the realized gain or loss value that the system calculates during payment application or for a maintenance worksheet.
63	ITEM_ACCTG_DT	Date	Optional	For multicurrency processing, enter the accounting date of the original item on certain subsequent entries.
64	VAT_ENTITY	Character	Optional	For VAT processing, enter a VAT entity for an accounts receivable business unit through a PeopleSoft General Ledger business unit.
65	VAT_CALC_GROSS_NET	Character	Optional	Select either the Gross or Net calculation type.
66	VAT_EXCPTN_TYPE	Character	Optional	Enter a VAT exception type, if applicable.
67	VAT_EXCPTN_CERTIF	Character	Optional	Enter a VAT exception certificate number, if applicable.
68	VAT_DCLRTN_POINT	Character	Optional	Enter a declaration point of either Payment or Invoice.
69	VAT_RECALC_FLG	Character	Optional	Select this option only if the VAT calculation type is Gross. If it is selected, the system recalculates the VAT discount amount at the payment time.
70	VAT_BASIS_AMT	Number	Optional	Enter the sales amount that the system uses to calculate the VAT amount.
71	VAT_BASIS_AMT_BASE	Number	Optional	Enter the VAT basis amount in the business unit base currency.
72	VAT_AMT	Number	Optional	If you convert or interface VAT information, provide the VAT amount for the item in the entry currency. Otherwise, enter 0. If you enter a value, the sum of the VAT_AMT in the PENDING_VAT rows for this item must equal this amount.
73	VAT_AMT_BASE	Number	Optional	The system calculates this amount by multiplying the VAT_AMT by the exchange rate that is used for the pending item. If you create accounting entries during the Receivables Update process, you must supply a value that is not 0.
74	COUNTRY_VAT_BILLFR	Character	Optional	If you convert or interface VAT information, provide the country code of the country where the invoice is generated.
75	COUNTRY_VAT_BILLTO	Character	Optional	If you convert or interface VAT information, provide the country code of the country where the invoice is sent.
76	COUNTRY_SHIP_TO	Character	Optional	If you convert or interface VAT information, provide the country code of the country where the invoice contents are shipped.
77	COUNTRY_SHIP_FROM	Character	Optional	If you convert or interface VAT information, provide the country code of the country from which the invoice contents are shipped.
78	VAT_DISTRIB_FLG	Character	Optional	Select or deselect the VAT distribution flag to indicate whether VAT information is distributed to the VAT Transaction Loader. The Receivables Update process updates this field.
79	VAT_RGSTRN_BUYER	Character	Optional	Enter the VAT registration ID of the buyer.
80	VAT_DST_ACCT_TYPE	Character	Optional	The system enters the VAT distribution account type. This field is populated by the system depending on the declaration point and transaction type (invoice, payment, write-off, and so on).
81	VAT_ROUND_RULE	Character	Optional	Indicates if the VAT amounts should be rounded up or down, or if it is regular rounding.
82	ORDER_NO	Character	Optional	Enter the order number that is associated with the item.
83	CONTRACT_NUM	Character	Optional	Enter the contract number that is associated with the item.
84	BUSINESS_UNIT_BI	Character	Optional	Enter the billing business unit for the item.
85	BUSINESS_UNIT_OM	Character	Optional	Enter the order management business unit for the item.
86	ADDRESS_SEQ_NUM	Number	Optional	The address location for the item. Select from the values on PS_ CUST_ADDRESS that are associated with the customer on the item.
87	LETTER_CD	Character	Optional	If you convert dunning letter information, enter the letter code of the most recent letter that contained the item. Otherwise, enter a space.
88	CONSOL_BUS_UNIT	Character	Optional	If you use PeopleSoft Billing, this field contains the business unit value that is associated with the consolidated bill. If you do not use PeopleSoft Billing, you may use the field for a similar purpose.
89	CONSOL_INVOICE	Character	Optional	If you use PeopleSoft Billing, this field contains the invoice identifier that is associated with the consolidated bill. If you do not use PeopleSoft Billing, you may use the field for a similar purpose.
90	PAYMENT_METHOD	Character	Optional	Enter CC for credit card, DR for draft, DD for direct debit, EFT for electronic funds transfer, GE for acceptgiro payments, or CHK for all other forms of payment. If you enter a space and do not provide a value, the Receivables Update process uses the default that you establish for the customer or business unit.
91	DRAFT_BU	Character	Optional	The draft creation process maintains this field.
92	DRAFT_ID	Character	Optional	The draft creation process maintains this field.
93	DRAFT_APPROVAL	Character	Optional	If the payment method is draft, enter P (preapproved) or R (approval required). If you enter a space and do not provide a value, the Receivables Update process uses the default that you establish for the customer or business unit.
94	DRAFT_DOC	Character	Optional	If the payment method is draft, enter C (create document) or N (do not create document). If you enter a space and do not provide a value, the Receivables Update process uses the default that you establish for the customer or business unit.
95	DRAFT_CURRENCY	Character	Optional	The draft creation process maintains this field.
96	DRAFT_FORMAT	Character	Optional	If the payment method is draft, enter M (multiple items per draft) or S to indicate that this item has its own draft.
97	DRAFT_AMT	Number	Optional	The draft creation process maintains this field.
98	BANK_SETID	Character	Optional	If you use the PeopleSoft Cash Management cash positioning options, enter the SetID that is associated with the bank from which you expect payment for this receivable. PeopleSoft Receivables does not use this field in the Cash Forecast report.
99	BANK_CD	Character	Optional	If you use the PeopleSoft Cash Management cash positioning options, enter the bank code that is associated with the bank from which you expect payment for this receivable. PeopleSoft Receivables does not use this field in the Cash Forecast report.
100	BANK_ACCT_KEY	Character	Optional	If you use PeopleSoft Cash Management cash positioning options, enter the bank account key that is associated with the bank account from which you expect payment for this receivable. PeopleSoft Receivables does not use this field in the Cash Forecast report.
101	DD_BU	Character	Optional	The Create Direct Debits Application Engine process (AR_DIRDEBIT) maintains this field.
102	DD_ID	Character	Optional	The Create Direct Debits process maintains this field.
103	DD_STATUS	Character	Optional	The Create Direct Debits process maintains this field.
104	DD_PROFILE_ID	Character	Optional	Direct debit profile that is assigned to the item. The profile defines the direct debit processing rules for the item.
105	DD_CURRENCY	Character	Optional	The Create Direct Debits process maintains this field.
106	DD_AMT	Number	Optional	The Create Direct Debits process maintains this field.
107	DD_AMT_BASE	Number	Optional	The Create Direct Debits process maintains this field.
108	DRAFT_TYPE	Character	Optional	Select from the values that you establish in the PS_DRAFT_TYPE_TBL table.
109	DRAFT_AMT_BASE	Number	Optional	Draft amount in the business unit base currency.
110	DOC_TYPE	Character	Optional	Document type represents the business purpose of the financial transaction. It is assigned to only one journal code. Note: You must include a value in this field if you enable the Document Sequencing option for installation and the PeopleSoft General Ledger business unit is associated with the PeopleSoft Receivables business unit.
111	DOC_SEQ_NBR	Character	Optional	The document sequencing number is either automatically assigned or manually entered sequentially based on the PeopleSoft General Ledger business period at either the journal code level or the document type level within journal code. Note: You must include a value in this field if you turn on the Document Sequencing option for your installation and the PeopleSoft General Ledger business unit is associated with the PeopleSoft Receivables business unit.
112	DOC_SEQ_DATE	Date	Required	Date that the document sequencing number is assigned to a specific document or the date that the document was created. The system automatically populates this field for items that you enter online. However, you must include a value in this field if you turn on the Document Sequencing option for your installation and the PeopleSoft General Ledger business unit is associated with the PeopleSoft Receivables business unit. Note: The Receivables Update process requires a value in this field to post an item.
113	DOC_SEQ_STATUS	Character	Optional	The status that is used for posting a document with document sequencing. If blank, then the document is valid for posting.
114	PROCESS_INSTANCE	Number	Optional	Enter 0. The Receivables Update process uses this field.
115	USER_AMT1	Number	Optional	This field is for your use.
116	USER_AMT2	Number	Optional	This field is for your use.
117	USER_AMT3	Number	Optional	This field is for your use.
118	USER_AMT4	Number	Optional	This field is for your use.
119	USER_AMT5	Number	Optional	This field is for your use.
120	USER_AMT6	Number	Optional	This field is for your use.
121	USER_AMT7	Number	Optional	This field is for your use.
122	USER_AMT8	Number	Optional	This field is for your use.
123	USER_DT1	Date	Optional	This field is for your use.
124	USER_DT2	Date	Optional	This field is for your use.
125	USER_DT3	Date	Optional	This field is for your use.
126	USER_DT4	Date	Optional	This field is for your use.
127	USER1	Character	Optional	This field is for your use.
128	USER2	Character	Optional	This field is for your use.
129	USER3	Character	Optional	This field is for your use.
130	USER4	Character	Optional	This field is for your use.
131	USER5	Character	Optional	This field is for your use.
132	USER6	Character	Optional	This field is for your use.
133	USER7	Character	Optional	This field is for your use.
134	USER8	Character	Optional	This field is for your use.
135	USER9	Character	Optional	This field is for your use.
136	USER10	Character	Optional	This field is for your use.
137	DOUBTFUL	Character	Optional	Flag to indicate that an item is a doubtful receivable (one for which you do not expect to receive payment). The Receivables Update process updates this field. Enter a space.
138	DRAFT_BUSN_EVENT	Character	Optional	Action that is taken on an item during draft processing. The Receivables Update process updates this field. Enter a space.
139	DRAFT_SUB_EVENT	Character	Optional	Action that is taken on an item during draft processing. The Receivables Update process updates this field. Enter a space.
140	SALES_PERSON2	Character	Optional	Second team member that is assigned to the item. Select from the values that are established on the PS_TEAM_MEMBERS or enter a space.
141	REGION_CD	Character	Optional	Region code for the team members that are assigned to the item. Enter a value from the PS_REGION_CD table or enter a space.
142	REVALUE_FLAG	Character	Optional	Flag to indicate whether to revalue the item if its currency is different from the base currency. Enter Y to revalue the item. Otherwise, enter N.
143	PACKSLIP_NO	Character	Optional	The packing slip number that is associated with the item.
144	SBI_NUM	Character	Optional	Self-billed invoice number. This field is currently not used by PeopleSoft Receivables. You can populate it if you want to use it for custom reports.
145	PC_DISTRIB_STATUS	Character	Optional	Flag that indicates the status for distributing the item to PeopleSoft Project Costing. Enter D to indicate the item is already in PeopleSoft Project Costing, H to hold the item, I to ignore the item, M to indicate that the item was changed, or N to integrate the item in a project.
146	VAT_ADVPAY_FLG	Character	Optional	Flag to indicate if VAT was paid when you entered the advance payment for the item. Enter Y to indicate that VAT is paid on the advance payment. Otherwise, enter N.
147	LC_ID	Character	Optional	The letter of credit number that is associated with the item. The bank includes this number with the payment. You use it to match the payment with the item.
148	AR_SEQ_NUM	Number	Optional	The Receivables Update process updates this field when you create a draft item for a pending item. Enter a space.
149	DRAFT_POST_ACTION	Character	Optional	The system maintains this value for draft processing. Enter a space.
150	VAT_TRANS_AMT	Sign	Optional	Total amount of the item on which VAT is calculated.
151	RECEIVABLE_TYPE	Character	Optional	Receivable type code that is used to categorize information on the Receivables Due From Public report. Select a value that is defined on the PS_REC_TYPE_TBL.
152	ENTITY_CODE	Character	Optional	Entity code identifying a government agency for the Receivables Due From Public report. Select a value that is defined on the PS_ENTITY_TBL.
153	CONTROL_AMT	Sign	Optional	Control amount for worksheets. Enter a space.
154	CONTROL_AMT_BASE	Sign	Optional	Control amount in the base currency for worksheets. Enter a space.
155	ANCHOR_BU	Character	Optional	Anchor business unit for maintenance worksheets. Enter a space.
156	ITM_PAY_AMT_BASE	Sign	Optional	Used by the system when the payment amount is in the base currency. Enter a space.
158	CLAIM_NO	Character	Optional	Claim number for deductions.
159	CONTROL_CURRENCY	Character	Optional	Control currency for maintenance worksheets. Enter a space.
160	CONTROL_CURR_BASE	Character	Optional	Base control currency for maintenance worksheets. Enter a space.
161	CONTROL_RATE_MULT	Sign	Optional	Control rate at which the taxes are calculated. The value that appears here is determined by the value in the Calc Scheme (calculation scheme) field and is always a percentage.
162	CONTROL_RATE_DIV	Number	Optional	Control rate at which the taxes are calculated. The value that appears here is determined by the value in the Calc Scheme field and is always a percentage.
163	CONTROL_RT_TYPE	Character	Optional	Control rate type to use to calculate the exchange rate between the default reporting currency code and the override currency code.
164	AR_SPECIALIST	Character	Optional	An assignment of the pending item to an AR specialist. Select from the values that you establish in the PS_AR_SPECIALIST table.
165	BROKER_ID	Character	Optional	Identifier code for the customer broker. Select from the values that you establish on the PS_CUSTOMER table where the Broker flag is checked.
166	CARRIER_ID	Character	Optional	Unique identifier for the shipping carrier. Select from the values that you establish on the PS_CARRIER_ID table.
167	CLAIM_DT	Date	Optional	Date of claim or debit memo.
168	CLASS_OF_TRADE	Character	Optional	Type of industry market, such as groceries, hardware, appliances.
169	DEDUCTION_STATUS	Character	Optional	Indicates the reason that an item is a deduction. Select from the values that you establish on the PS_DEDUCTION_TBL.
170	DEDUCTION_DT	Date	Optional	Date that the deduction was created.
171	DIVISION	Character	Optional	Geographic area within an organization.
172	DT_INVOICED	Date	Optional	The date that the associated invoice was created. The date is established when the invoice is created the billing system. This value cannot be changed.
173	INV_PROD_FAM_CD	Character	Optional	Identifier that defines inventory items at a high level. Examples might include computer items and office furniture. Select a value that is defined on the PS_INV_ITEM_FAM table.
174	INVOICE	Character	Optional	Original invoice that is associated with the item.
175	INVOICE_BU	Character	Optional	Code to identify the PeopleSoft business unit that is associated with an invoice.
176	MAJOR_CLASS	Character	Optional	Identifier for a group of customers in a trade, such as grocers or mass merchandisers.
177	MEMO_STATUS_CD	Character	Optional	(USF) Code that indicates the current status of a delinquent item. Enter a value that you defined on the MEMO_STATUS_TBL table.
179	PROOF_OF_DELIVERY	Character	Optional	Proof of delivery slip number.
180	SHIP_FROM_BU	Character	Optional	Ship from business unit.
181	SHIP_TO_ADDR_NUM	Number	Optional	Address location for the ship to customer. Select from the values on the PS_CUST_ADDRESS table for the customer.
182	SHIP_TO_CUST_ID	Character	Optional	Customer ID of the ship to customer.
183	SOLD_TO_ADDR_NUM	Number	Optional	Address location for the sold to customer. Select from the values on the PS_CUST_ADDRESS table for the customer.
184	SOLD_TO_CUST_ID	Character	Optional	Customer ID for the sold to customer.
185	SUB_GROUP_ID	Number	Optional	Used by the Automatic Maintenance process and the maintenance worksheet to identify the match group in which items are matched. Enter 99999.
186	VAT_TREATMENT_GRP	Character	Optional	A set of VAT treatments that are permissible on a single VAT transaction.
187	PHYSICAL_NATURE	Character	Optional	Identifies the nature of a transaction for VAT calculation. Values are: G: physical good. S: intangible or service.
188	COUNTRY_LOC_BUYER	Character	Optional	Country where the buyer is physically located.
189	STATE_LOC_BUYER	Character	Optional	State where the buyer is physically located.
190	COUNTRY_LOC_SELLER	Character	Optional	Country where the seller is physically located.
191	STATE_LOC_SELLER	Character	Optional	State where the seller is physically located.
192	VAT_SVC_SUPPLY_FLG	Character	Optional	Flag to indicate if the buyer or supplier rendered the service and where the service was performed. Values are: 1: Supplier's Location. 2: Buyer's location. 3: Where the service is physically performed.
193	VAT_SERVICE_TYPE	Character	Optional	Flag to indicate whether the service is freight transport. This flag enables other types of services to be identified. Valid values are 1: Freight Transport, 2: Other.
194	COUNTRY_VAT_PERFRM	Character	Optional	The country where the VAT service was performed.
195	STATE_VAT_PERFRM	Character	Optional	The state where the VAT service was performed.
196	COUNTRY_VAT_SUPPLY	Character	Optional	Country where the service is physically performed.
197	STATE_VAT_SUPPLY	Character	Optional	State where the service is physically performed.
198	STATE_SHIP_FROM	Character	Optional	The state from which the items that are billed on this line are shipped.
199	STATE_SHIP_TO	Character	Optional	The state to which the items that are billed on this line are shipped.
200	VAT_RPT_CNTRY_SRC	Character	Optional	Source for the VAT reporting country. Enter one of these values: 1: Ship from country. 2: Ship to country. 3: Country in the VAT entity. 4: Service Performed in country. 5: Supplier location country. 6: Buyer location country. 7: Buyer registration country.
201	STATE_VAT_DEFAULT	Character	Optional	Enter the state or province that is used to determine the VAT defaults if the Track VAT by Province field (COUNTRY_VAT_SUBD_FLG) on the COUNTRY_VAT_TBL is set to Y.
202	DISC_TAKEN	Sign	Optional	Discount that is taken for the line in the entry currency. If there is no discount amount, enter zero.
203	GL_LVL	Character	Optional	The general ledger level flag that is carried from billing indicates whether PeopleSoft Billing is to create accounting entries for a receivables item. This controls the action that is available in external pending item entry. Levels are: A: PeopleSoft Receivables creates general ledger accounting entries. B: PeopleSoft Billing creates accounting entries. N: No general ledger accounting entries are created.
204	ITEM_LINE_ORIG	Number	Optional	The line number of the original item for new overdue charge item lines that were created when the option Create Charge by Item Line is selected on the overdue charge ID. It allows new items to point back to the item for overdue charges.
205	TOT_TAX_AMT	Sign	Optional	Total tax amount on the schedule. This amount is the sum of the excise tax amount and sales tax amount for India.
206	TOT_TAX_AMT_BSE	Sign	Optional	The base amount that the system uses when calculating taxes for India.
207	TOT_EXD_AMT	Sign	Optional	Total excise duty tax amount for India. Required if the excise tax is applicable.
208	TOT_EXD_AMT_BSE	Sign	Optional	The base amount that the system uses when calculating excise taxes for India.
209	TOT_STX_AMT	Sign	Optional	Total sales tax amount for India. Required if the sales tax is applicable.
210	TOT_STX_AMT_BSE	Sign	Optional	The base amount that the system uses when calculating sales taxes for India.
211	AG_REF_NBR	Number	Optional	(NLD) The payment reference number from the acceptgiro form attached to the invoice.
212	AR_IU_REQ	Character	Optional	Leave blank. The system enters Y in this field if you modify ChartField values online that are balancing ChartFields to enable the Inter/Intraunit processor to generate interunit accounting entries.
213	CLAIM_SETID	Character	Optional	Leave blank. PeopleSoft Purchasing and PeopleSoft Order Management populate this field with a claim SetID for vendor rebates or claim backs when you interface claims to PeopleSoft Receivables.