Populate the INTFC_BI table for AHDR transactions
The following table demonstrates how to populate the INTFC_BI fields for AHDR transactions:
| Field Number | Field Name | Required for AHDR Transactions? | Remarks |
|---|---|---|---|
|
1 |
INTFC_ID (interface ID) |
Required. |
Used to group or batch a collection of Billing interface activity. |
|
2 |
INTFC_LINE_NUM (interface line number) |
Required. |
Each unique interface line number for an interface ID with AHDR transaction guarantees uniqueness. |
|
3 |
TRANS_TYPE_BI (transaction type) |
Required. |
Value must be AHDR. |
|
4 |
TRANS_TYPE_BI_SEQ (transaction type sequence) |
Required. |
Initialize to zero for AHDR transaction type. |
|
7 |
ADJ_TRANS_TYPE (adjustment transaction type) |
Required. |
Must be CRALL for Credit Entire Bill or RBALL for Rebill Entire Bill. |
|
9 |
TMP_BILL_FLG (temporary bill flag) |
Leave blank. |
Temporary bills are not supported for adjustments. |
|
10 |
ENTRY_TYPE |
Optional. |
|
|
11 |
ENTRY_REASON |
Optional. |
|
|
12 |
ENTRY_EVENT |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
13 |
LOAD_STATUS_BI |
Optional. |
May initialize to NEW or leave blank. |
|
15 |
BUSINESS_UNIT (billing business unit) |
Required. |
Must be a valid billing business unit. |
|
17 |
BILL_TO_CUST_ID (bill-to customer) |
Required. |
Must be a valid bill-to customer. Leave blank for India tax transactions populated by PeopleSoft Order Management. AHDR is not supported for India transactions. |
|
18 |
ADDRESS_SEQ_NUM (address sequence number) |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. Leave blank for India tax transactions populated by PeopleSoft Order Management. |
|
20 |
CNTCT_SEQ_NUM (contact sequence number) |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
23 |
BUSINESS_UNIT_TO |
Conditional. |
Leave blank for CRALL For RBALL, if not populated and if the customer is an InterUnit customer, the system uses the BUSINESS_UNIT_GL value from the CUST_OPTION table, based on the customer ID. If the system cannot obtain this value, it marks the transaction in error. |
|
24 |
DIRECT_INVOICING |
Optional. |
Bills set to Y are created in RDY bill status. If provided, it must be valid and included in the bill-by definition. If not provided, defaults to N. |
|
25 |
RANGE_SELECTION_ID |
Optional. |
Used in range selection options and with direct invoicing. |
|
26 |
BILL_SOURCE_ID |
Required only if invoice numbering by bill source. |
Must be a valid bill source if provided. |
|
27 |
BILL_TYPE_ID |
Required. |
Must be a valid bill type. |
|
28 |
BILL_CYCLE_ID |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
29 |
BILL_BY_ID (bill-by identifier) |
Conditional. |
Leave blank for CRALL. Must be valid if provided for RBALL. Defaults if left blank. |
|
30 |
PAYMENT_METHOD (payment method) |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
31 |
PYMNT_TERMS_CD (payment terms code) |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
32 |
BANK_CD (bank code) |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
33 |
BANK_ACCT_KEY |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
34 |
BI_CURRENCY_CD (billing transaction currency) |
Conditional. |
Leave blank for CRALL. For RBALL, must be the same currency as the bill being adjusted. |
|
36 |
CUR_RT_TYPE (currency rate type) |
Conditional. |
Leave blank for CRALL. Must be valid if provided for RBALL. Defaults if left blank. |
|
37 |
RATE_MULT (rate multiplier) |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process sets it to 0 (zero) |
|
38 |
RATE_DIV (rate divisor) |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process sets it to 1. |
|
39 |
CUR_RT_SOURCE (currency rate source) |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
40 |
INVOICE_DT (invoice date) |
Optional. |
|
|
41 |
ACCOUNTING_DT (accounting date) |
Optional. |
|
|
43 |
TARGET_INVOICE |
Optional. |
If passed, target invoice becomes the invoice number. |
|
45 |
DOC_TYPE (document type) |
Optional. |
|
|
46 |
CONSOL_SETID (consolidation customer SetID) |
Leave blank. |
Not supported for adjustments. |
|
47 |
CONSOL_CUST_ID (consolidation customer ID) |
Leave blank. |
Not supported for adjustments. |
|
48 |
CONSOL_KEY (consolidation key) |
Leave blank. |
Not supported for adjustments. |
|
49 |
INVOICE_TO_ADJ |
Required. |
Invoice to be adjusted must be a valid invoice. |
|
95 |
BUSINESS_UNIT_OM (PeopleSoft Order Management business unit) |
Conditional. |
Leave blank for CRALL. Required for RBALL if PRODUCT_ID is populated or when India tax transactions are populated by PeopleSoft Order Management. |
|
96 |
ORDER_NO (order number) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
102 |
RMA_ID (RMA identifier) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
103 |
RMA_LINE_NBR (RMA line number) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
105 |
ORDER_DATE |
Conditional. |
Leave blank for CRALL. For RBALL, required for contract liability if recognition basis is ORD (order date). |
|
106 |
PO_REF (purchase order number) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
114 |
COUNTRY_SHIP_FROM |
Conditional. |
Leave blank for CRALL and India tax transactions populated by PeopleSoft Order Management. If not provided for RBALL, the system obtains a default value from the ship-from business unit, then from the billing business unit location for VAT transactions. |
|
115 |
COUNTRY_SHIP_TO |
Conditional. |
Leave blank for CRALL and India tax transactions populated by PeopleSoft Order Management. If not provided for RBALL, the system obtains a default value from the ship-to customer location for VAT transactions. |
|
116 |
SHIP_TO_CUST_ID (ship-to customer) |
Conditional. |
Leave blank for CRALL and India tax transactions populated by PeopleSoft Order Management. For RBALL VAT transactions, if you do not provide a value, the Billing Interface process attempts to provide a default value in this manner:
|
|
117 |
SHIP_TO_ADDR_NUM (ship-to address) |
Conditional. |
Leave blank for CRALL and India tax transactions populated by PeopleSoft Order Management. For RBALL VAT transactions, if you do not provide a value, the Billing Interface process attempts to provide a default value in this manner:
|
|
118 |
SHIP_ID (shipment ID) |
Conditional. |
Leave blank for CRALL and India tax transactions populated by PeopleSoft Order Management. Optional for RBALL. |
|
119 |
SHIP_TYPE_ID (shipment type) |
Conditional. |
Leave blank for CRALL and India tax transactions populated by PeopleSoft Order Management. Optional for RBALL. |
|
120 |
SHIP_FROM_BU (ship-from business unit) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
123 |
PACKSLIP_NO (packing slip number) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
124 |
LC_ID (letter of credit ID) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
125 |
LOC_DOC_ID (location document ID) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
127 |
SOLD_TO_CUST_ID (sold to customer) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
128 |
SOLD_TO_ADDR_NUM (sold to address number) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
129 |
BUSINESS_UNIT_PC (PeopleSoft Project Costing business unit) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
130 |
BUSINESS_UNIT_CA (PeopleSoft Contracts business unit) |
Conditional. |
Leave blank for CRALL. Required for RBALL if PRODUCT_ID from PROD_ITEM table is populated by PeopleSoft Contracts. |
|
132 |
BILL_PLAN_ID |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
134 |
BPLAN_LN_NBR (bill plan line number) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
135 |
EVENT_OCCURRENCE |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
137 |
CONTRACT_PPD_SEQ (prepaid add sequence) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
138 |
ANALYSIS_TYPE |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
140 |
RESOURCE_TYPE |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
141 |
RESOURCE_CATEGORY |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
142 |
RESOURCE_SUB_CAT (resource subcategory) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
143 |
ACTIVITY_ID |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
144 |
ACTIVITY_TYPE |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
145 |
DIST_CFG_FLAG |
Conditional. |
Leave blank for CRALL. For RBALL, set to either Y or N. When an item is configurable, set to Y. |
|
146 |
PRODUCT_KIT_ID |
Conditional. |
Leave blank for CRALL and India tax transactions populated by PeopleSoft Order Management. Optional for RBALL. |
|
147 |
SYSTEM_SOURCE |
Same as LINE for RBALL. See Understanding Guidelines for Creating Adjustments. |
Leave blank for CRALL. For RBALL of PeopleSoft Order Management sales orders: OBI. For RBALL of PeopleSoft Order Management and Inventory returns: OBI. For RBALL of PeopleSoft Inventory: IBI. For PeopleSoft Contracts: CBI. For RBALL of PeopleSoft Project Costing: PBI. For RBALL of PeopleSoft Asset Managements: ABI. If left blank, the Billing Interface process uses BBI as the default value. |
|
148 |
EMPLID (employee ID) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
150 |
START_DT |
Conditional. |
Leave blank for CRALL. Required for RBALL with contract liability if recognition basis is STE (start and end date range). |
|
151 |
END_DT |
Conditional. |
Leave blank for CRALL. Required for RBALL with contract liability if recognition basis is STE (start and end date range). |
|
152 |
FROM_DT |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
153 |
TO_DT |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
154 |
SERVICE_CUST_ID (service customer) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
155 |
SERVICE_ADDR_NUM (service address) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
164 |
BILLING_SPECIALIST |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
165 |
BILLING_AUTHORITY |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
166 |
BILLING_FREQUENCY |
Conditional. |
Leave blank for CRALL. For RBALL, ONC (once) is the default value, if left blank. |
|
167 |
BILL_INQUIRY_PHONE |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
168 |
SALES_PERSON |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
169 |
COLLECTOR |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
170 |
CR_ANALYST |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
171 |
INVOICE_FORM_ID |
Conditional. |
Leave blank for CRALL. If provided for RBALL, it must be valid and included in the bill-by definition. If not provided, the Billing Interface process obtains a default value from the setup tables, based on the PeopleSoft Billing default hierarchy. |
|
179 |
SSN (social security number) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
182 |
SUBCUST_QUAL1 (subcustomer qualifier 1) |
Conditional. |
Leave blank for CRALL. If not populated for RBALL, the system defaults subcustomer1 from bill-to customer setup. |
|
183 |
SUBCUST_QUAL2 (subcustomer qualifier 2) |
Conditional. |
Leave blank for CRALL. If not populated for RBALL, the system defaults subcustomer2 from bill-to customer setup. |
|
184 |
REIMB_AGREEMENT |
Optional. |
|
|
231 |
USER_AMT1 (user amount 1) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
232 |
USER_AMT2 (user amount 2) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
233 |
USER_DT1 (user date 1) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
234 |
USER_DT2 (user date 1) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
235 |
USER1 (user field 1) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
236 |
USER2 (user field 2) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
237 |
USER3 (user field 3) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
238 |
USER4 (user field 4) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
239 |
USER5 (user field 5) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
240 |
USER6 (user field 6) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
241 |
USER7 (user field 7) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
242 |
USER8 (user field 8) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
243 |
USER9 (user field 9) |
Optional. |
Leave blank for CRALL. Optional for RBALL. |
|
246 |
ADD_DTTM |
Optional. |
Allows accurate reporting on interface activity. Used by interface workflow functions. |