17: doc_type_tbl PO_TBL_VARCHAR30,
18: doc_subtype_tbl PO_TBL_VARCHAR30,
19: rate_type_tbl PO_TBL_VARCHAR30,
20: rate_type_code_tbl PO_TBL_VARCHAR30,
21: rate_date_tbl PO_TBL_DATE,
22: rate_tbl PO_TBL_NUMBER,
23: agent_id_tbl PO_TBL_NUMBER,
24: agent_name_tbl PO_TBL_VARCHAR2000,
25: ship_to_loc_id_tbl PO_TBL_NUMBER,
44: shipping_control_tbl PO_TBL_VARCHAR30,
45: currency_code_tbl PO_TBL_VARCHAR30,
46: quote_warning_delay_tbl PO_TBL_NUMBER,
47: approval_required_flag_tbl PO_TBL_VARCHAR1,
48: reply_date_tbl PO_TBL_DATE,
49: approval_status_tbl PO_TBL_VARCHAR30,
50: approved_date_tbl PO_TBL_DATE,
51: from_type_lookup_code_tbl PO_TBL_VARCHAR30,
52: revision_num_tbl PO_TBL_NUMBER,
46: quote_warning_delay_tbl PO_TBL_NUMBER,
47: approval_required_flag_tbl PO_TBL_VARCHAR1,
48: reply_date_tbl PO_TBL_DATE,
49: approval_status_tbl PO_TBL_VARCHAR30,
50: approved_date_tbl PO_TBL_DATE,
51: from_type_lookup_code_tbl PO_TBL_VARCHAR30,
52: revision_num_tbl PO_TBL_NUMBER,
53: confirming_order_flag_tbl PO_TBL_VARCHAR1,
54: acceptance_required_flag_tbl PO_TBL_VARCHAR1,
58: frozen_flag_tbl PO_TBL_VARCHAR1,
59: encumbrance_required_flag_tbl PO_TBL_VARCHAR1,
60: vendor_doc_num_tbl PO_TBL_VARCHAR30,
61: org_id_tbl PO_TBL_NUMBER,
62: acceptance_due_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
64: effective_date_tbl PO_TBL_DATE,
65: expiration_date_tbl PO_TBL_DATE,
66: po_release_id_tbl PO_TBL_NUMBER,
60: vendor_doc_num_tbl PO_TBL_VARCHAR30,
61: org_id_tbl PO_TBL_NUMBER,
62: acceptance_due_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
64: effective_date_tbl PO_TBL_DATE,
65: expiration_date_tbl PO_TBL_DATE,
66: po_release_id_tbl PO_TBL_NUMBER,
67: release_num_tbl PO_TBL_NUMBER,
68: release_date_tbl PO_TBL_DATE,
61: org_id_tbl PO_TBL_NUMBER,
62: acceptance_due_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
64: effective_date_tbl PO_TBL_DATE,
65: expiration_date_tbl PO_TBL_DATE,
66: po_release_id_tbl PO_TBL_NUMBER,
67: release_num_tbl PO_TBL_NUMBER,
68: release_date_tbl PO_TBL_DATE,
69: revised_date_tbl PO_TBL_DATE,
64: effective_date_tbl PO_TBL_DATE,
65: expiration_date_tbl PO_TBL_DATE,
66: po_release_id_tbl PO_TBL_NUMBER,
67: release_num_tbl PO_TBL_NUMBER,
68: release_date_tbl PO_TBL_DATE,
69: revised_date_tbl PO_TBL_DATE,
70: printed_date_tbl PO_TBL_DATE,
71: closed_date_tbl PO_TBL_DATE,
72: amount_agreed_tbl PO_TBL_NUMBER,
65: expiration_date_tbl PO_TBL_DATE,
66: po_release_id_tbl PO_TBL_NUMBER,
67: release_num_tbl PO_TBL_NUMBER,
68: release_date_tbl PO_TBL_DATE,
69: revised_date_tbl PO_TBL_DATE,
70: printed_date_tbl PO_TBL_DATE,
71: closed_date_tbl PO_TBL_DATE,
72: amount_agreed_tbl PO_TBL_NUMBER,
73: amount_limit_tbl PO_TBL_NUMBER, -- bug5352625
66: po_release_id_tbl PO_TBL_NUMBER,
67: release_num_tbl PO_TBL_NUMBER,
68: release_date_tbl PO_TBL_DATE,
69: revised_date_tbl PO_TBL_DATE,
70: printed_date_tbl PO_TBL_DATE,
71: closed_date_tbl PO_TBL_DATE,
72: amount_agreed_tbl PO_TBL_NUMBER,
73: amount_limit_tbl PO_TBL_NUMBER, -- bug5352625
74: firm_flag_tbl PO_TBL_VARCHAR30,
67: release_num_tbl PO_TBL_NUMBER,
68: release_date_tbl PO_TBL_DATE,
69: revised_date_tbl PO_TBL_DATE,
70: printed_date_tbl PO_TBL_DATE,
71: closed_date_tbl PO_TBL_DATE,
72: amount_agreed_tbl PO_TBL_NUMBER,
73: amount_limit_tbl PO_TBL_NUMBER, -- bug5352625
74: firm_flag_tbl PO_TBL_VARCHAR30,
75: gl_encumbered_date_tbl PO_TBL_DATE,
71: closed_date_tbl PO_TBL_DATE,
72: amount_agreed_tbl PO_TBL_NUMBER,
73: amount_limit_tbl PO_TBL_NUMBER, -- bug5352625
74: firm_flag_tbl PO_TBL_VARCHAR30,
75: gl_encumbered_date_tbl PO_TBL_DATE,
76: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
77: budget_account_id_tbl PO_TBL_NUMBER,
78: budget_account_tbl PO_TBL_VARCHAR2000,
79: budget_account_segment1_tbl PO_TBL_VARCHAR30,
111: style_display_name_tbl PO_TBL_VARCHAR2000,
112: global_agreement_flag_tbl PO_TBL_VARCHAR1,
113:
114: -- standard who columns
115: last_update_date_tbl PO_TBL_DATE,
116: last_updated_by_tbl PO_TBL_NUMBER,
117: last_update_login_tbl PO_TBL_NUMBER,
118: creation_date_tbl PO_TBL_DATE,
119: created_by_tbl PO_TBL_NUMBER,
114: -- standard who columns
115: last_update_date_tbl PO_TBL_DATE,
116: last_updated_by_tbl PO_TBL_NUMBER,
117: last_update_login_tbl PO_TBL_NUMBER,
118: creation_date_tbl PO_TBL_DATE,
119: created_by_tbl PO_TBL_NUMBER,
120: request_id_tbl PO_TBL_NUMBER,
121: program_application_id_tbl PO_TBL_NUMBER,
122: program_id_tbl PO_TBL_NUMBER,
119: created_by_tbl PO_TBL_NUMBER,
120: request_id_tbl PO_TBL_NUMBER,
121: program_application_id_tbl PO_TBL_NUMBER,
122: program_id_tbl PO_TBL_NUMBER,
123: program_update_date_tbl PO_TBL_DATE,
124:
125: -- attributes not read from interface table but exist in txn table
126: status_lookup_code_tbl PO_TBL_VARCHAR30,
127: cancel_flag_tbl PO_TBL_VARCHAR1,
196: quantity_tbl PO_TBL_NUMBER,
197: line_num_tbl PO_TBL_NUMBER,
198: shipment_num_tbl PO_TBL_NUMBER,
199: price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
200: effective_date_tbl PO_TBL_DATE,
201: expiration_date_tbl PO_TBL_DATE,
202: attribute14_tbl PO_TBL_VARCHAR2000,
203: price_update_tolerance_tbl PO_TBL_NUMBER,
204: line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
197: line_num_tbl PO_TBL_NUMBER,
198: shipment_num_tbl PO_TBL_NUMBER,
199: price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
200: effective_date_tbl PO_TBL_DATE,
201: expiration_date_tbl PO_TBL_DATE,
202: attribute14_tbl PO_TBL_VARCHAR2000,
203: price_update_tolerance_tbl PO_TBL_NUMBER,
204: line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
205: negotiated_flag_tbl PO_TBL_VARCHAR1,
214: contract_num_tbl PO_TBL_VARCHAR30,
215: contract_id_tbl PO_TBL_NUMBER,
216: type_1099_tbl PO_TBL_VARCHAR30,
217: closed_by_tbl PO_TBL_NUMBER,
218: closed_date_tbl PO_TBL_DATE,
219: committed_amount_tbl PO_TBL_NUMBER,
220: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
221: weight_uom_code_tbl PO_TBL_VARCHAR5,
222: volume_uom_code_tbl PO_TBL_VARCHAR5,
228: file_line_language_tbl PO_TBL_VARCHAR5, -- bug 5489942
229:
230: -- standard who columns
231: last_updated_by_tbl PO_TBL_NUMBER,
232: last_update_date_tbl PO_TBL_DATE,
233: last_update_login_tbl PO_TBL_NUMBER,
234: creation_date_tbl PO_TBL_DATE,
235: created_by_tbl PO_TBL_NUMBER,
236: request_id_tbl PO_TBL_NUMBER,
230: -- standard who columns
231: last_updated_by_tbl PO_TBL_NUMBER,
232: last_update_date_tbl PO_TBL_DATE,
233: last_update_login_tbl PO_TBL_NUMBER,
234: creation_date_tbl PO_TBL_DATE,
235: created_by_tbl PO_TBL_NUMBER,
236: request_id_tbl PO_TBL_NUMBER,
237: program_application_id_tbl PO_TBL_NUMBER,
238: program_id_tbl PO_TBL_NUMBER,
235: created_by_tbl PO_TBL_NUMBER,
236: request_id_tbl PO_TBL_NUMBER,
237: program_application_id_tbl PO_TBL_NUMBER,
238: program_id_tbl PO_TBL_NUMBER,
239: program_update_date_tbl PO_TBL_DATE,
240:
241: -- attributes that are in line txn table but not in interface table
242: order_type_lookup_code_tbl PO_TBL_VARCHAR30,
243: purchase_basis_tbl PO_TBL_VARCHAR30,
252: hd_action_tbl PO_TBL_VARCHAR30,
253: hd_po_header_id_tbl PO_TBL_NUMBER,
254: hd_vendor_id_tbl PO_TBL_NUMBER,
255: hd_min_release_amount_tbl PO_TBL_NUMBER,
256: hd_start_date_tbl PO_TBL_DATE,
257: hd_end_date_tbl PO_TBL_DATE,
258: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
259: hd_currency_code_tbl PO_TBL_VARCHAR30,
260: hd_created_language_tbl PO_TBL_VARCHAR5,
253: hd_po_header_id_tbl PO_TBL_NUMBER,
254: hd_vendor_id_tbl PO_TBL_NUMBER,
255: hd_min_release_amount_tbl PO_TBL_NUMBER,
256: hd_start_date_tbl PO_TBL_DATE,
257: hd_end_date_tbl PO_TBL_DATE,
258: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
259: hd_currency_code_tbl PO_TBL_VARCHAR30,
260: hd_created_language_tbl PO_TBL_VARCHAR5,
261: hd_style_id_tbl PO_TBL_NUMBER,
319: firm_flag_tbl PO_TBL_VARCHAR30,
320: fob_tbl PO_TBL_VARCHAR30,
321: freight_carrier_tbl PO_TBL_VARCHAR30,
322: freight_term_tbl PO_TBL_VARCHAR30,
323: need_by_date_tbl PO_TBL_DATE,
324: promised_date_tbl PO_TBL_DATE,
325: quantity_tbl PO_TBL_NUMBER,
326: start_date_tbl PO_TBL_DATE,
327: end_date_tbl PO_TBL_DATE,
320: fob_tbl PO_TBL_VARCHAR30,
321: freight_carrier_tbl PO_TBL_VARCHAR30,
322: freight_term_tbl PO_TBL_VARCHAR30,
323: need_by_date_tbl PO_TBL_DATE,
324: promised_date_tbl PO_TBL_DATE,
325: quantity_tbl PO_TBL_NUMBER,
326: start_date_tbl PO_TBL_DATE,
327: end_date_tbl PO_TBL_DATE,
328: note_to_receiver_tbl PO_TBL_VARCHAR2000,
322: freight_term_tbl PO_TBL_VARCHAR30,
323: need_by_date_tbl PO_TBL_DATE,
324: promised_date_tbl PO_TBL_DATE,
325: quantity_tbl PO_TBL_NUMBER,
326: start_date_tbl PO_TBL_DATE,
327: end_date_tbl PO_TBL_DATE,
328: note_to_receiver_tbl PO_TBL_VARCHAR2000,
329: price_discount_tbl PO_TBL_NUMBER,
330: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
323: need_by_date_tbl PO_TBL_DATE,
324: promised_date_tbl PO_TBL_DATE,
325: quantity_tbl PO_TBL_NUMBER,
326: start_date_tbl PO_TBL_DATE,
327: end_date_tbl PO_TBL_DATE,
328: note_to_receiver_tbl PO_TBL_VARCHAR2000,
329: price_discount_tbl PO_TBL_NUMBER,
330: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
331: secondary_quantity_tbl PO_TBL_NUMBER,
344: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
345:
346: -- standard who columns
347: last_updated_by_tbl PO_TBL_NUMBER,
348: last_update_date_tbl PO_TBL_DATE,
349: last_update_login_tbl PO_TBL_NUMBER,
350: creation_date_tbl PO_TBL_DATE,
351: created_by_tbl PO_TBL_NUMBER,
352: request_id_tbl PO_TBL_NUMBER,
346: -- standard who columns
347: last_updated_by_tbl PO_TBL_NUMBER,
348: last_update_date_tbl PO_TBL_DATE,
349: last_update_login_tbl PO_TBL_NUMBER,
350: creation_date_tbl PO_TBL_DATE,
351: created_by_tbl PO_TBL_NUMBER,
352: request_id_tbl PO_TBL_NUMBER,
353: program_application_id_tbl PO_TBL_NUMBER,
354: program_id_tbl PO_TBL_NUMBER,
351: created_by_tbl PO_TBL_NUMBER,
352: request_id_tbl PO_TBL_NUMBER,
353: program_application_id_tbl PO_TBL_NUMBER,
354: program_id_tbl PO_TBL_NUMBER,
355: program_update_date_tbl PO_TBL_DATE,
356:
357: -- attributes read from the line interface record
358: ln_po_line_id_tbl PO_TBL_NUMBER,
359: ln_item_id_tbl PO_TBL_NUMBER,
365: ln_closed_code_tbl PO_TBL_VARCHAR30,
366: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
367: ln_matching_basis_tbl PO_TBL_VARCHAR30,
368: ln_item_revision_tbl PO_TBL_VARCHAR5,
369: ln_expiration_date_tbl PO_TBL_DATE,
370: ln_government_context_tbl PO_TBL_VARCHAR30,
371: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
372: ln_closed_date_tbl PO_TBL_DATE,
373: ln_closed_by_tbl PO_TBL_NUMBER,
368: ln_item_revision_tbl PO_TBL_VARCHAR5,
369: ln_expiration_date_tbl PO_TBL_DATE,
370: ln_government_context_tbl PO_TBL_VARCHAR30,
371: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
372: ln_closed_date_tbl PO_TBL_DATE,
373: ln_closed_by_tbl PO_TBL_NUMBER,
374: ln_from_header_id_tbl PO_TBL_NUMBER,
375: ln_from_line_id_tbl PO_TBL_NUMBER,
376: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
385: hd_fob_tbl PO_TBL_VARCHAR30,
386: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
387: hd_freight_term_tbl PO_TBL_VARCHAR30,
388: hd_approved_flag_tbl PO_TBL_VARCHAR1,
389: hd_effective_date_tbl PO_TBL_DATE,
390: hd_expiration_date_tbl PO_TBL_DATE,
391: hd_style_id_tbl PO_TBL_NUMBER,
392:
393: -- attributes added for item processing(read from line)
386: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
387: hd_freight_term_tbl PO_TBL_VARCHAR30,
388: hd_approved_flag_tbl PO_TBL_VARCHAR1,
389: hd_effective_date_tbl PO_TBL_DATE,
390: hd_expiration_date_tbl PO_TBL_DATE,
391: hd_style_id_tbl PO_TBL_NUMBER,
392:
393: -- attributes added for item processing(read from line)
394: --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
473: expenditure_tbl PO_TBL_VARCHAR100,
474: expenditure_type_tbl PO_TBL_VARCHAR30,
475: expenditure_org_tbl PO_TBL_VARCHAR100,
476: expenditure_org_id_tbl PO_TBL_NUMBER,
477: expenditure_item_date_tbl PO_TBL_DATE,
478: end_item_unit_number_tbl PO_TBL_VARCHAR30,
479: dest_context_tbl PO_TBL_VARCHAR30,
480: gl_encumbered_date_tbl PO_TBL_DATE,
481: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
476: expenditure_org_id_tbl PO_TBL_NUMBER,
477: expenditure_item_date_tbl PO_TBL_DATE,
478: end_item_unit_number_tbl PO_TBL_VARCHAR30,
479: dest_context_tbl PO_TBL_VARCHAR30,
480: gl_encumbered_date_tbl PO_TBL_DATE,
481: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
482: variance_account_id_tbl PO_TBL_NUMBER,
483: accrual_account_id_tbl PO_TBL_NUMBER,
484: budget_account_id_tbl PO_TBL_NUMBER,
539: dist_attribute15_tbl PO_TBL_VARCHAR2000,
540:
541: -- standard who columns
542: last_updated_by_tbl PO_TBL_NUMBER,
543: last_update_date_tbl PO_TBL_DATE,
544: last_update_login_tbl PO_TBL_NUMBER,
545: creation_date_tbl PO_TBL_DATE,
546: created_by_tbl PO_TBL_NUMBER,
547: request_id_tbl PO_TBL_NUMBER,
541: -- standard who columns
542: last_updated_by_tbl PO_TBL_NUMBER,
543: last_update_date_tbl PO_TBL_DATE,
544: last_update_login_tbl PO_TBL_NUMBER,
545: creation_date_tbl PO_TBL_DATE,
546: created_by_tbl PO_TBL_NUMBER,
547: request_id_tbl PO_TBL_NUMBER,
548: program_application_id_tbl PO_TBL_NUMBER,
549: program_id_tbl PO_TBL_NUMBER,
546: created_by_tbl PO_TBL_NUMBER,
547: request_id_tbl PO_TBL_NUMBER,
548: program_application_id_tbl PO_TBL_NUMBER,
549: program_id_tbl PO_TBL_NUMBER,
550: program_update_date_tbl PO_TBL_DATE,
551:
552: -- attributes exist in txn table but not in interface table
553: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
554: award_set_id_tbl PO_TBL_NUMBER, -- bug5201306
558: loc_line_loc_id_tbl PO_TBL_NUMBER,
559: loc_shipment_type_tbl PO_TBL_VARCHAR30,
560: loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
561: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
562: loc_need_by_date_tbl PO_TBL_DATE,
563: loc_promised_date_tbl PO_TBL_DATE,
564: loc_price_override_tbl PO_TBL_NUMBER,
565: loc_outsourced_assembly_tbl PO_TBL_NUMBER,
566: loc_attribute1_tbl PO_TBL_VARCHAR2000,
559: loc_shipment_type_tbl PO_TBL_VARCHAR30,
560: loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
561: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
562: loc_need_by_date_tbl PO_TBL_DATE,
563: loc_promised_date_tbl PO_TBL_DATE,
564: loc_price_override_tbl PO_TBL_NUMBER,
565: loc_outsourced_assembly_tbl PO_TBL_NUMBER,
566: loc_attribute1_tbl PO_TBL_VARCHAR2000,
567: loc_attribute2_tbl PO_TBL_VARCHAR2000,
605: -- attributes read from header record
606: draft_id_tbl PO_TBL_NUMBER,
607: hd_agent_id_tbl PO_TBL_NUMBER,
608: hd_po_header_id_tbl PO_TBL_NUMBER,
609: hd_rate_date_tbl PO_TBL_DATE,
610: hd_rate_tbl PO_TBL_NUMBER,
611: hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
612: hd_vendor_id_tbl PO_TBL_NUMBER,
613: hd_attribute1_tbl PO_TBL_VARCHAR2000,