Infolinks

Thursday 21 June 2012

XXFTCOOT RTF (XXFTC_OPEN_ORDER_LINES_FC_V1)


IF
Customer Details
<?xdofx:sysdate(‘DD-MON-YYYY HH:MI:SS’)?>

IF
Warehouse
Order Type
Account #
Customer
Ship To
Po#
Order#
Line#
Item

Cust Item No
Description
Ordered Date
Quantity
Ordered Weight
Reserved Quantity
Reserved Weight
Available Qty
List Price
Selling Price
Salesrep
F WAREHOUSE2
ORDER_TYPE
ACCOUNT_NUMBER
CUSTOMER_NAME1
SHIP_TO
CUSTOMER_PO
ORDER_NUMBER
LINE_NUMBER
ITEM
CUSTOMER_ITEM_NUMBER
DESCRIPTION
ORDERED_DATE 
QUANTITY
ORDERED_WEIGHT
RESERVED_QUANTITY
RESERVED_WEIGHT
AVAILABLE_QTY
LIST_PRICE
SELLING_PRICE
SALESREPE
END IF

IF
Warehouse
Order Type
Account #
Customer
Ship To
Po#
Order#
Line#
Item

Cust Item No
Description
Ordered Date
Quantity
Ordered Weight
Reserved Quantity
Reserved Weight
List Price
Selling Price
Salesrep
F WAREHOUSE2
ORDER_TYPE
ACCOUNT_NUMBER
CUSTOMER_NAME1
SHIP_TO
CUSTOMER_PO
ORDER_NUMBER
LINE_NUMBER
ITEM
CUSTOMER_ITEM_NUMBER
DESCRIPTION
ORDERED_DATE 
QUANTITY
ORDERED_WEIGHT
RESERVED_QUANTITY
RESERVED_WEIGHT
LIST_PRICE
SELLING_PRICE
SALESREPE
END IF
EIF

IF
Falken Summary
<?xdofx:sysdate(‘DD-MON-YYYY HH:MI:SS’)?>

Warehouse
Order Type
Customer Name
Ship To
Po#
Order#
Order Status
Ord Date
Quantity SUM
Ordered Weight SUM
Reserved Quantity SUM
Reserved Weight SUM
List price SUM
Selling price SUM
Ship Method
F WAREHOUSE4
ORDER_TYPE1
CUSTOMER_NAME
SHIP_TO1
CUSTOMER_PO1
ORDER_NUMBER1
ORDER_STATUS
ORDERED_DATE1 
SUM_XOOLF_QUANTITY
SUM_XOOLF_ORDERED_WEIGHT
SUM_XOOLF_RESERVED_QUANTITY
SUM_XOOLF_RESERVED_WEIGHT
SUM_XOOLF_LIST_PRICE
SUM_XOOLF_SELLING_PRICE
SHIP_METHOD
E
EIF

No comments:

Post a Comment