Return to Overview
...
Name | Description | Type | Example |
---|---|---|---|
Start Date | Start of product time-series. Empty by default, you are free to fill in as necessary. | Date (YYYY-MM-DD) | 2015-06-01 |
End Date | End of product time-series. Today's date by default. | Date (YYYY-MM-DD) | 2019-06-14 |
Auto Update | Tick: Resets the dates to default once you leave the ‘Dashboard’ page. Untick: Dates according to your settings remain unchanged once you leave the ‘Dashboard’ page. | Checkbox | - |
Comments | Useful for documentation purposes or for settings description. | Text | - |
...
Description | Type | |
---|---|---|
Product/Strategy Information | Basically if input data in PS Ledger, the total quantity and amount with PSL TYPE as INVOICE for the trade will be reflected as SETTLED quantity and amount in the Physical Trade Status app; otherwise, will be reflected in UNSETTLED quantity and amount. If input data in PS Ledger, the total quantity and amount with PSL TYPE as PAYMENT for the trade will be reflected as SETTLED quantity and amount in the Physical Trade Status app; otherwise, will be reflected in UNSETTLED quantity and amount. This app uses Contract No. to link the stock in/out cargo to the contract, allowing accurate monitoring of cargo quantity and amount. If the undelivered/open quantity and amount (Unsettled Qty and Unsettled Amount) are displayed in red, it means that the inventory has not been completed yet, allowing you to monitor and manage your outstanding contracts more efficiently. STATUS: If all unsettled contract is settled (quantity and amount displayed as 0), the status will auto become "settled" UNSETTLED QTY: UNSETTLED AMT: For stock contract quantity that has not been input as PAYMENT (PSL TYPE) into PS Ledgers table, the total stock amount will be reflected as Unsettled Amt in the app UNSETTLED INV QTY: UNSETTLED INV AMT: For stock contract quantity that has not been input as INVOICE (PSL TYPE) into PS Ledgers table, the total stock amount will be reflected as Unsettled Inv Amt in the app SETTLED QTY: SETTLED AMT: If you input the stock contract as PAYMENT (PSL TYPE) into PS Ledgers table, the total stock amount will be reflected as Settled Amt in the app SETTLED INV QTY: If you input the stock contract as INVOICE (PSL TYPE) into PS Ledgers table, the total stock quantity will be reflected as Settled Inv Qty in the app SETTLED INV AMT: If you input the stock contract as INVOICE (PSL TYPE) into PS Ledgers table, the total stock amount will be reflected as Settled Inv Amt in the app
| Text |
...
Example
Add a column called ACTUAL QTY (实际量) after CONTRACT QTY
SETTLED QTY now is ACTUAL QTY
UNSETTED QTY = ACTUAL QTY - SETTLED QTY
UNSETTED INV QTY = SETTLED QTY - INVOICE QTY
Example:
After inputting a new trade and its title transfer date, the trade will appear in the Physical Trade Status table.
...