|
| bill_to_cust_id
| number
| input
| no
| BILL_TO_CUSTOMER_ID
|
| ship_to_cust_id
| number
| input
| yes
| SHIP_TO_CUSTOMER_ID
|
| customer_trx_id
| number
| input
| yes
| TRX_HEADER_ID
|
| trx_number
| number
| input
| yes
| TRX_NUMBER
|
| bill_to_customer_
number
| number
| input
| yes
| BILL_TO_CUSTOMER_NUMBER
|
| ship_to_customer_
number
| number
| input
| yes
| SHIP_TO_CUSTOMER_NUMBER
|
| bill_to_customer_
name
| varchar2
| input
| yes
| BILL_TO_CUSTOMER_NAME
|
| ship_to_customer_
name
| varchar2
| input
| yes
| SHIP_TO_CUSTOMER_NAME
|
| previous_customer_
trx_id
| number
| input
| yes
| PREVIOUS_TRX_HEADER_ID
|
| previous_trx_number
| number
| input
| yes
| PREVIOUS_TRX_NUMBER
|
| trx_date
| date
| input
| yes
| TRX_DATE
|
| gl_date
| date
| input
| yes
| GL_DATE
|
| ship_to_site_use_id
| number
| input
| yes
| SHIP_TO_SITE_USE_ID
|
| bill_to_site_use_id
| number
| input
| yes
| BILL_TO_SITE_USE_ID
|
| ship_to_postal_code
| varchar2
| input
| yes
| SHIP_TO_POSTAL_CODE
|
| bill_to_postal_code
| varchar
| input
| yes
| BILL_TO_POSTAL_CODE
|
| ship_to_location_id
| number
| input
| yes
| SHIP_TO_LOCATION_CCID
|
| bill_to_location_id
| number
| input
| yes
| BILL_TO_LOCATION_CCID
|
| invoicing_rule_id
| number
| input
| yes
| INVOICING_RULE_ID
|
| fob_point
| varchar2
| input
| yes
| FOB_CODE
|
| trx_currency_code
| varchar2
| input
| yes
| CURRENCY_CODE
|
| trx_exchange_rate
| number
| input
| yes
| EXCHANGE_RATE
|
| minimum_
accountable_unit
| number
| input/output
| yes
| MINIMUM_ACCOUNTABLE_
UNIT
|
| precision
| number
| input/output
| yes
| PRECISION
|
| tax_header_level_flag
| varchar2
| input
| yes
| TAX_HEADER_LEVEL_FLAG
|
| tax_rounding_rule
| varchar2
| input
| yes
| TAX_ROUNDING_RULE
|
| trx_type_id
| number
| input
| yes
| TRX_TYPE_ID
|
| ship_from_warehouse_id
| number
| input
| yes
| SHIP_FROM_WAREHOUSE_ID
|
| payment_term_id
| number
| input
| yes
| PAYMENT_TERM_ID
|
| customer_trx_line_id
| number
| input
| yes
| TRX_LINE_ID
|
| previous_customer_
trx_line_id
| number
| input
| yes
| PREVIOUS_TRX_LINE_ID
|
| link_to_cust_trx_line_id
| number
| input
| yes
| TRX_LINK_TO_CUST_TRX_
LINE_ID
|
| memo_line_id
| number
| input
| yes
| MEMO_LINE_ID
|
| taxed_quantity
| number
| input
| yes
| TAXED_QUANTITY
|
| inventory_item_id
| number
| input
| yes
| INVENTORY_ITEM_ID
|
| extended_amount
| number
| input
| yes
| EXTENDED_AMOUNT
|
| tax_code
| varchar2
| input/output
| yes
| TAX_CODE
|
| vat_tax_id
| number
| input/output
| yes
| VAT_TAX_ID
|
| tax_exemption_id
| number
| input/output
| yes
| VAT_TAX_ID
|
| item_exception_rate_
id
| number
| input/output
| yes
| TAX_EXCEPTION_ID
|
| tax_rate
| number
| input/output
| yes
| TAX_RATE
|
| default_ussgl_
transaction_code
| varchar2
| input
| yes
| USSGL_TRANSACTION_CODE
|
| amount_includes_tax_flag
| varchar2
| input
| no
| AMOUNT_INCLUDES_TAX_
FLAG
|
| taxable_basis
| varchar2
| input
| yes
| TAXABLE_BASIS
|
| tax_calculation_plsql_block
| varchar2
| input
| yes
| TAX_CALCULATION_
PLSQL_BLOCK
|
| payment_terms_
discount_percent
| varchar2
| input
| yes
| PAYMENT_TERMS_
DISCOUNT_PERCENT
|
| audit_flag
| varchar2
| input
| no
| AUDIT_FLAG
|
| qualifier
| varchar2
| input
| no
| LOCATION_QUALIFIER
|
| ship_from_code
| varchar2
| input
| yes
| SHIP_FROM_ADDRESS_CODE
|
| ship_to_code
| varchar2
| input
| yes
| SHIP_TO_ADDRESS_CODE
|
| poo_code
| varchar2
| input
| yes
| POO_ADDRESS_CODE
|
| poa_code
| varchar2
| input
| yes
| POA_ADDRESS_CODE
|
| vdrctrl_exempt
| varchar2
| input
| yes
| VENDOR_CONTROL_
EXEMPTIONS
|
| tax_control
| varchar2
| input/output
| yes
| TAX_EXEMPT_FLAG
|
| xmpt_cert_no
| varchar2
| input/output
| yes
| TAX_EXEMPT_NUMBER
|
| xmpt_reason
| varchar2
| input/output
| yes
| TAX_EXEMPT_REASON
|
| xmpt_percent
| number
| input/output
| yes
| TAX_EXEMPT_PERCENT
|
| trx_line_type
| varchar2
| input
| yes
| TRX_LINE_TYPE
|
| part_no
| varchar2
| input
| yes
| PART_NUMBER
|
| division_code
| varchar2
| input
| yes
| DIVISION_CODE
|
| company_code
| varchar2
| input
| yes
| COMPANY_CODE
|
| userf1-10
| varchar2
| input
| yes
| ATTRIBUTE1-10
|
| usern1-10
| number
| input
| yes
| NUMERIC_ATTRIBUTE1-10
|
| calculate_tax
| varchar2
| input
| yes
| TAXABLE_FLAG
|
| status
| number
| input
| no
| default return code
|
| credit_memo_flag
| boolean
| input
| no
| True if credit memo
|
| tax_line_number
| number
| input
| yes
| TAX_LINE_NUMBER
|
| tax_amount
| number
| input/output
| yes
| TAX_AMOUNT
|
| tax_vendor_return_
code
| varchar2
| output
| no
|
|
