| Output Name |
Type |
Details |
| $record |
ASSOC |
Details follow: |
| $record / company_id |
INT |
references: ar_detail.company_id |
| $record / system_order_number |
STRING |
references: ar_detail.system_order_number |
| $record / warehouse_code |
STRING |
references: ar_detail.warehouse_code |
| $record / suborder_counter |
INT |
references: ar_detail.suborder_counter |
| $record / customer_code |
STRING |
references: ar_detail.customer_code |
| $record / customer_terms_type |
STRING |
references: ar_detail.customer_terms_type |
| $record / customer_po |
STRING |
references: ar_detail.customer_po |
| $record / tax_jurisdiction_id |
INT |
references: ar_detail.tax_jurisdiction_id |
| $record / tax_exempt_flag |
BOOLEAN |
references: ar_detail.tax_exempt_flag |
| $record / tax_rate |
NUMERIC |
references: ar_detail.tax_rate |
| $record / tax_type |
CHAR |
references: ar_detail.tax_type |
| $record / shipping_city |
STRING |
references: ar_detail.shipping_city |
| $record / shipping_locality |
STRING |
references: ar_detail.shipping_locality |
| $record / date_due |
DATE |
YYYY-MM-DD |
|
|
rreferences: ar_detail.date_due |
| $record / date_ordered |
DATE |
YYYY-MM-DD HH24:MI |
|
|
rreferences: ar_detail.date_ordered |
| $record / date_confirmed |
DATE |
YYYY-MM-DD HH24:MI |
|
|
rreferences: ar_detail.date_confirmed |
| $record / date_invoiced |
DATE |
YYYY-MM-DD HH24:MI |
|
|
references: ar_detail.date_invoiced |
| $record / item_total |
MONETARY |
references: ar_detail.item_total |
| $record / nonstock_item_total |
MONETARY |
references: ar_detail.nonstock_item_total |
| $record / direct_ship_item_total |
MONETARY |
references: ar_detail.direct_ship_item_total |
| $record / returns_total |
MONETARY |
references: ar_detail.returns_total |
| $record / labor_total |
MONETARY |
references: ar_detail.labor_total |
| $record / freight_in |
MONETARY |
references: ar_detail.freight_in |
| $record / freight_out |
MONETARY |
references: ar_detail.freight_out |
| $record / prepaid_allow_freight |
MONETARY |
references: ar_detail.prepaid_allow_freight |
| $record / collect_freight |
MONETARY |
references: ar_detail.collect_freight |
| $record / misc_charges_total |
MONETARY |
references: ar_detail.misc_charges_total |
| $record / state_tax |
MONETARY |
references: ar_detail.state_tax |
| $record / county_tax |
MONETARY |
references: ar_detail.county_tax |
| $record / city_tax |
MONETARY |
references: ar_detail.city_tax |
| $record / opt1_tax |
MONETARY |
references: ar_detail.opt1_tax |
| $record / opt2_tax |
MONETARY |
references: ar_detail.opt2_tax |
| $record / opt3_tax |
MONETARY |
references: ar_detail.opt3_tax |
| $record / sales_tax_total |
MONETARY |
references: ar_detail.sales_tax_total |
| $record / order_total |
MONETARY |
references: ar_detail.order_total |
| $record / taxable_merchandise_total |
MONETARY |
references: ar_detail.taxable_merchandise_total |
| $record / taxable_misc_charges_total |
MONETARY |
references: ar_detail.taxable_misc_charges_total |
| $record / taxable_labor_total |
MONETARY |
references: ar_detail.taxable_labor_total |
| $record / taxable_freight_total |
MONETARY |
references: ar_detail.taxable_freight_total |
| $record / cost_total |
MONETARY |
references: ar_detail.cost_total |
| $record / nonstock_cost_total |
MONETARY |
references: ar_detail.nonstock_cost_total |
| $record / labor_cost_total |
MONETARY |
references: ar_detail.labor_cost_total |
| $record / claims_cost_total |
MONETARY |
references: ar_detail.claims_cost_total |
| $record / amount_paid |
MONETARY |
references: ar_detail.amount_paid |
| $record / adjustment_total |
MONETARY |
references: ar_detail.adjustment_total |
| $record / check_date |
DATE |
YYYY-MM-DD |
|
|
references: ar_detail.check_date |
| $record / payment_verification |
STRING |
references: ar_detail.payment_verification |
| $record / comment_code |
INT |
references: ar_detail_comment_master.comment_code |