FTP FILE LAYOUT - MOCAS ATTACHMENT

 

S_TRN_TYPE

S_TRN_TYPE Description

Line Item (Source or "Value") - Group By

Line Item Type ("Value")

Stock Number ( Source, "Value", Or N/A)

Product Service Type ("Value")

*Description (Source)

Quantity Shipped/Invoiced (Source, "Value", or N/A)

Unit of Measure Code (Source, "Value", or N/A)

Unit Price (Source or N/A)

B

Burden

Default CLIN/ACRN Mapping/CLIN Mapping

1

Follows Logic of Billed Amt on which Burden is Computed.

Follows Logic of Billed Amt on which Burden is Computed.

Follows Logic of Billed Amt on which Burden is Computed.

Follows Logic of Billed Amt on which Burden is Computed.

Follows Logic of Billed Amt on which Burden is Computed

BILL_EDIT_DETL.mu_bill_amt

C

Cost

Default CLIN/ACRN Mapping/CLIN Mapping

1

If SVC Exists in Line 3, Insert SERVICES. If any other value, insert NONE.

If SVC Exists in Line 3, Insert SV. If not insert MG.

Amount Billed for XXXXXX

1

EA

BILL_EDIT_DETL.mu_bill_amt

C - Tax

Tax on Cost

"LS"

4

N/A

N/A

BILL_EDIT_DETL.bill_fm_ln_lbl

N/A

N/A

BILL_EDIT_DETL.mu_sales_tax_amt  (if BILL_EDIT_DETL.sales_tax_cd is not null)

C - Tax

Tax on Cost

Follows Taxable Amount (Included Discount and Taxes in CLIN is Selected)

1

Follows Logic of Taxable Costs.

Follows Logic of Taxable Costs.

Follows Logic of Taxable Costs.

Follows Logic of Taxable Costs.

Follows Logic of Taxable Costs

BILL_EDIT_DETL.mu_sales_tax_amt  (if BILL_EDIT_DETL.sales_tax_cd is not null)

COM

Cost of Money

Default CLIN/ACRN Mapping/CLIN Mapping

1

Follows Logic of Billed Amt on which COM is Computed.

Follows Logic of Billed Amt on which COM is Computed.

Follows Logic of Billed Amt on which COM is Computed.

Follows Logic of Billed Amt on which COM is Computed.

Follows Logic of Billed Amt on which COM is Computed.

BILL_EDIT_DETL.mu_bill_amt

DOL

Discount on Labor

"C310"

3

N/A

N/A

Discount

N/A

N/A

BILL_EDIT_DETL.mu_disc_amt

DOL

Discount on Labor

Follows Discounted Amount (Included Discount and Taxes in CLIN is selected)

1

Follows Logic of Discounted Amount.

Follows Logic of Discounted Amount.

Follows Logic of Discounted Amount.

Follows Logic of Discounted Amount.

Follows Logic of Discounted Amount.

BILL_EDIT_DETL.mu_disc_amt

DNL

Discount on Non-Labor

"C310"

3

N/A

N/A

Discount

N/A

N/A

BILL_EDIT_DETL.mu_disc_amt

DNL

Discount on Non-Labor

Follows Discounted Amount (Included Discount and Taxes in CLIN is selected)

1

Follows Logic of Discounted Amount.

Follows Logic of Discounted Amount.

Follows Logic of Discounted Amount.

Follows Logic of Discounted Amount.

Follows Logic of Discounted Amount.

BILL_EDIT_DETL.mu_disc_amt

F

Fee

Default CLIN/ACRN Mapping/CLIN Mapping

1

Follows Logic of Billed Amt on which Fee is Computed.

Follows Logic of Billed Amt on which Fee is Computed.

Follows Logic of Billed Amt on which Fee is Computed.

Follows Logic of Billed Amt on which Fee is Computed.

Follows Logic of Billed Amt on which Fee is Computed.

BILL_EDIT_DETL.mu_bill_amt

FH

Fee on Hours

Default CLIN/ACRN Mapping/CLIN Mapping

1

Follows Logic of Billed Hours on which Fee is Computed.

Follows Logic of Billed Hours on which Fee is Computed.

Follows Logic of Billed Hours on which Fee is Computed.

Follows Logic of Billed Hours on which Fee is Computed.

Follows Logic of Billed Hours on which Fee is Computed.

BILL_EDIT_DETL.mu_bill_amt

FL

Fee on Labor

Default CLIN/ACRN Mapping/CLIN Mapping

1

Follows Logic of Billed Amt on which Fee is Computed.

Follows Logic of Billed Amt on which Fee is Computed.

Follows Logic of Billed Amt on which Fee is Computed.

Follows Logic of Billed Amt on which Fee is Computed.

Follows Logic of Billed Amt on which Fee is Computed.

BILL_EDIT_DETL.mu_bill_amt

H

Hours

Default CLIN/ACRN Mapping/CLIN Mapping

1

If SVC Exists in Line 3, Insert SERVICES.  If any other value, insert NONE.

If SVC Exists in Line 3, Insert SV. If not insert MG.

Amount Billed for XXXXXX

1

EA

BILL_EDIT_DETL.mu_bill_amt

OC

Over Cost Ceiling

Computed in "Helper" Table at Detail Level.  Follows Mapping Method (Default CLIN, ACRN Mapping, CLIN Mapping)

1

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies..

Follows Logic of Billed Amounts to Which Ceiling Applies.

Over Cost Ceiling from Helper Table

OF

Over Fee Ceiling

Computed in "Helper" Table at Detail Level.  Follows Mapping Method (Default CLIN, ACRN Mapping, CLIN Mapping)

1

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Over Fee Ceiling from Helper Table

OT

Over Total Ceiling

Computed in "Helper" Table at Detail Level.  Follows Mapping Method (Default CLIN, ACRN Mapping, CLIN Mapping)

1

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Follows Logic of Billed Amounts to Which Ceiling Applies.

Over Total Ceiling from Helper Table

**R

Retainage

Computed in "Helper" Table at Detail Level.  Follows Mapping Method (Default CLIN, ACRN Mapping, CLIN Mapping)

1

Follows Logic of Billed Amounts to Which Retainage Applies.

Follows Logic of Billed Amounts to Which Retainage Applies.

Follows Logic of Billed Amounts to Which Retainage Applies.

Follows Logic of Billed Amounts to Which Retainage Applies.

Follows Logic of Billed Amounts to Which Retainage Applies.

Retainage from Helper Table

SCH

Scheduled Amts

Default CLIN/ACRN Mapping/CLIN Mapping

1

N/A

"MG"

Amount Billed for XXXXXX

1

EA

BILL_EDIT_DETL.mu_bill_amt

U

Units

Group Units by Account using Mapping Method (Default CLIN/ACRN Mapping/CLIN Mapping) when "Map Units by Account" is Selected.

1

If SVC Exists in Line 3, Insert 'SERVICES'. If any other value, insert 'NONE'.

If SVC Exists in Line 3, Insert SV. If not insert MG.

Amount Billed for XXXXXX

1

EA

BILL_EDIT_DETL.mu_bill_amt

U

Units

Group by BILL_EDIT_DETL.CLIN_ID or PRICE_CATLG_CD.  May Include Other Billed Amounts Mapped to Same CLIN/Catalog when Combine Units by Transaction CLIN is selected.

1

PART.NSN_ID or NONE if No NSN_ID Exists or Combining Multiple Items.  If SVC Exists in Line 3, Insert SERVICES.

FS if NSN_ID Exists and is Inserted in Stock Number.  If NONE is Used for Stock Number, use MG.  If SVC Exists in Line 3, insert 'SV'.

BILL_EDIT_DETL.ITEM_DESC if One Item is Included.  If More Than One Item, use Amount Billed for XXXXXXX.

BILL_EDIT_DETL.bill_qty

Use ITEM.DFLT_UM_CD if One Item.  If more than One Item, Use EA.

BILL_EDIT_DETL.mu_unit_price_amt

U - Tax

Tax on Units

"LS"

4

N/A

N/A

BILL_EDIT_DETL.bill_fm_ln_lbl

N/A

N/A

BILL_EDIT_DETL.mu_sales_tax_amt (if BILL_EDIT_DETL.sales_tax_cd is not null)

U - Tax

Tax on Units

Follows Taxable Units (Included Discount and Taxes in CLIN is Selected)

1

Follows Logic of Taxable Units.

Follows Logic of Taxable Units.

Follows Logic of Taxable Units

Follows Logic of Taxable Units.

Follows Logic of Taxable Units.

BILL_EDIT_DETL.mu_sales_tax_amt (if BILL_EDIT_DETL.sales_tax_cd is not null)

Other Charges

Other Charges

BILL_EDIT_INVC_HDR.oth_chg_cd 1, 2, 3

2

N/A

N/A

BILL_EDIT_INVC_HDR.oth_chg_desc1, 2, 3

N/A

N/A

BILL_EDIT_INVC_HDR.mu_oth_chg_amt1, 2, 3

 

  1. Group Tax on Units and Tax on Cost into one line if Include Discounts and Taxes in CLIN is not selected.

  2. If field is N/A, skip field.  Do not insert N/A.

  3. Insert the CLIN in the Code field in the Maintain Other Charges screen (Projects » Billing » Controls).

  4. Line Item Type of 3 or 4 can only have two digits to the right of the decimal.  Line type of 1 can have only four digits to the right of the decimal.

  5. No negative CLINs are acceptable in file.